--- Gianni Mariani <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
