kishore.sainath@xxxxxxxxx wrote: > How do I convert a database in the ASCII format into one of the UTF-8 > format? ASCII is a subset of UTF-8, so you don't need to do anything. Just change the encoding entry in the pg_database table. Of course, using pg_dump would be the official way to convert a database between any two encodings. -- Peter Eisentraut http://developer.postgresql.org/~petere/