On Sun, Jul 19, 2009 at 7:08 PM, Martijn van Oosterhout<kleptog@xxxxxxxxx> wrote: > On Sun, Jul 19, 2009 at 10:16:17AM +0800, Phoenix Kiula wrote: > Look through the archives, there are scripts that will scan all your > text fields for UTF-8 problems. If you run them once you can clear out > all the problems prior to upgrading. Thanks Martin. I tried searching through the archives and could only come with something like this: http://docs.moodle.org/en/UTF-8_PostgreSQL But this only has the usual iconv stuff suggested. Could you pls suggest some specific scripts or URLs? Or let me know the keywords I should look for? Thanks! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general