Re: UTF-8 to ASCII

From: LEGEAY Jérôme <jerome(dot)legeay(at)ffcat(dot)coop>
To: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: UTF-8 to ASCII
Date: 2007-05-11 12:34:37
Message-ID: 6.0.0.22.2.20070511142954.040aaed8@pop.ffcat.coop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

for convert my DB, i use this process:

createdb -T "old_DB" "copy_old_DB"
dropdb "old_DB"
createdb -E LATIN1 -T "copy_old_DB" "new_DB_name"

maybe this process will help you.

regards

Jérôme LEGEAY

Le 14:13 11/05/2007, vous avez écrit:
>I have a doubt about the function to_ascii() and what the documentation says.
>
>Basically, I passed my DB from latin1 to UTF-8, and I started getting an
>error when using the to_ascii() function on a field of one of my DB [1]:
>
>ERROR: la conversión de codificación de UTF8 a ASCII no está soportada
>
>OK, it's in spanish, but basically it says that the conversion UTF8 to
>ASCII is not supported, but in the documentation [2] I see this in the
>"Table 9-7. Built-in Conversions":
>
>utf8_to_ascii UTF8 SQL_ASCII
>
>Is the documentation wrong or something?
>
>I'm on postgresql-8.1.8, and as you can see, I'm checking the
>corresponding documentation.
>
>[1]: This I already solved using convert() to pass from UTF to Latin1, and
>after that I do a to_ascii().
>[2]:
>http://www.postgresql.org/docs/8.1/interactive/functions-string.html#FTN.AEN7625
>
>--
> 21:50:04 up 2 days, 9:07, 0 users, load average: 0.92, 0.37, 0.18
>---------------------------------------------------------
>Lic. Martín Marqués | SELECT 'mmarques' ||
>Centro de Telemática | '@' || 'unl.edu.ar';
>Universidad Nacional | DBA, Programador,
> del Litoral | Administrador
>---------------------------------------------------------
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin Marques 2007-05-11 12:46:52 Re: UTF-8 to ASCII
Previous Message Geoffrey 2007-05-11 12:32:59 Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)