12 May
2011
12 May
'11
3:22 p.m.
Vipin TS wrote:
Hello Nate,
Can you make sure that your dump was created with '-E UTF-8' flag?
I didn't use any customized encoding for my dump, took the default one, I believe which is the database encoding.
Also, in your old database server, use psql's '\l' command to show the encoding of your databases.
My database encoding is SQL_ASCII
Is your new database UTF-8? If so, you'll want to drop it and recreate in the same encoding as your source database. --nate
thanks, Vipin