Re: Going from a DB using SQL_ASCII to UNICODE

Tom,

I will try to add "set client_encoding = sql_ascii;" and pray :)

Cheers,

Dion

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Monday, April 19, 2004 9:21 PM
> To: Dion Almaer
> Cc: pgsql-admin(at)postgresql(dot)org; 'Lloyd Benson'; Eric Preston
> Subject: Re: [ADMIN] Going from a DB using SQL_ASCII to UNICODE
>
> "Dion Almaer" <dion(at)almaer(dot)com> writes:
> > When we try to import the data from a SQL_ASCII dumped db, into the
> > new UNICODE db, everything freaks out.
>
> I'm no expert on this stuff, but I think what you need to do is add
>
> set client_encoding = sql_ascii;
>
> to the top of the dump file. (As of fairly recently, pg_dump
> will automatically add such a SET, but I'm pretty sure 7.4.2 won't.)
>
> If that doesn't help, then what you have is actually not
> valid UTF-8 data, and what you'll have to do is figure out
> what encoding it's in and specify that instead. If it's in a
> mishmash of different encodings, you're in for some pain :-(
>
> regards, tom lane
>
>