On Jul 8, 2007, at 14:09 , Pat Maddox wrote:
Can I just convert it, or do I need to dump it, drop it, recreate with UTF-8, and then load the data?
It depends on what is currently in your (SQL_ASCII) database. If it's only ASCII data or all non-ASCII data is UTF-8, you should be okay just dumping the data and loading it into a new database with UTF8 encoding.
If this isn't the case, you'll need to clean the dump somehow, probably using iconv.
Also is it possible to change the default encoding for databases as well?
AFAIK, you can't change the default encoding after it's been set by initdb, but you can set the encoding at database creation time. See the CREATE DATABASE or createdb documentation on how to do this.
Michael Glaesemann grzm seespotcode net
