Re: convert database to unicode

--- Gianni Mariani <gianni(at)mariani(dot)ws> wrote: > David
Lutz wrote:
>
> >Hello, I want to convert an existing database with
> >SQL_ASCII encoding to UNICODE encoding.
> >
> >(postgresql ver 7.3.2)
> >
> >I thought that it might be as easy as:
> >pg_dump mydatabase > dump.sql
> >createdb --encoding=unicode newdatabase
> >psql newdatabase < dump.sql
> >
> You *might* be able to convert dump.sql to unicode.
>
> i.e.
>
> iconv -f iso8859-1 -t utf-8 < dump.sql >
> dump-utf-8.sql
>
> If all the bytea chars are appropriately escaped,
> this may do it.
>
> Can't harm in giving it a go !

Thanks Gianni, yes that appears to have worked.
I didn't know about the iconv command.

Cheers, David

http://search.yahoo.com.au - Yahoo! Search
- Looking for more? Try the new Yahoo! Search