Forgot to mention, we're using a very old version which is 8.3.11. I'll take a look at the guide for 8.3 with similar section. Thanks Adrian! -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxx] Sent: Friday, October 18, 2013 3:05 PM To: Huang, Suya; Steve Atkins; pgsql-general@xxxxxxxxxxxxxx General Subject: Re: [ADMIN] what's the efficient/safest way to convert database character set ? On 10/17/2013 08:51 PM, Huang, Suya wrote: > Thanks Steve, > > Yes, we're using SQL_ASCII. > > Would you please be more specific about manual data cleanup work here? I'm new to Postgres and don't have any experience in character set conversion before, so any specific experience shared would be very much appreciated. This is a good place to start: http://www.postgresql.org/docs/9.3/interactive/multibyte.html > > Thanks, > Suya > -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general