Jayadevan M wrote: > We have a PostgreSQL server with ASCII data. We have a > requirement for the db to support UTF also. Which is the best > approach - > 1) Make a new installation, move data This is the only and hence the best approach. It doesn't have to be a new installation, a new database with encoding UTF8 is enough. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general