Re: [GENERAL] UTF-8 to ASCII

2007-05-11 Thread Alvaro Herrera
Tom Lane escribió: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Why on earth is it talking about MULE_INTERNAL? > > IIRC, a lot of the conversions translate through some common > intermediate charset to save on code/table space. In such cases > the problem will usually be detected on the back

Re: [GENERAL] UTF-8 to ASCII

2007-05-11 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Why on earth is it talking about MULE_INTERNAL? IIRC, a lot of the conversions translate through some common intermediate charset to save on code/table space. In such cases the problem will usually be detected on the backend conversion...

Re: [GENERAL] UTF-8 to ASCII

2007-05-11 Thread Martin Gainty
ot; <[EMAIL PROTECTED]> Cc: Sent: Friday, May 11, 2007 9:33 AM Subject: Re: [GENERAL] UTF-8 to ASCII Martin Marques escribió: 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 us

Re: [GENERAL] UTF-8 to ASCII

2007-05-11 Thread Alvaro Herrera
Martin Marques escribió: > 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 codific

Re: [GENERAL] UTF-8 to ASCII

2007-05-11 Thread Martin Marques
Albe Laurenz wrote: [2]: http://www.postgresql.org/docs/8.1/interactive/functions-string.html#FTN.AEN7625 Well, the documentation for to_ascii states clearly: "The to_ascii function supports conversion from LATIN1, LATIN2, LATIN9, and WIN1250 encodings only." Sorry, didn't see the footn

Re: [GENERAL] UTF-8 to ASCII

2007-05-11 Thread Albe Laurenz
> 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 What do you mean by 'passed the DB from Latin1 to UTF8'? > getting an error when using the to_ascii() function on a field > of one of my DB [1]: >

Re: [GENERAL] UTF-8 to ASCII

2007-05-11 Thread Arnaud Lesauvage
Martin Marques a é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 UT

Re: [GENERAL] UTF-8 to ASCII

2007-05-11 Thread Martin Marques
LEGEAY Jérôme wrote: 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. As I said in my original mail, the DB conversion went OK, but I see some discrepancies in the do

Re: [GENERAL] UTF-8 to ASCII

2007-05-11 Thread LEGEAY Jérôme
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

[GENERAL] UTF-8 to ASCII

2007-05-11 Thread Martin Marques
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á soporta