On Jan 7, 2008 1:28 AM, Chuck <chuckr@xxxxxxxxxxxx> wrote:
> Since I had sent this email, I contacted my web host for help. They
> said that I could '-E UTF8 --no-locale' to the initdb call within
> /etc/init.db/postgresql. I stopped postgres, deleted the data
> directory and restarted postgres. My cluster was now using UTF-8:
Please note however, that individual database encoding can be set at
the time that the database is created, so you don't have to re-initdb
to do that. I.e.:
create database mydb with encoding 'UTF8';
create database yourdb with encoding 'SQLASCII';
\l
mydb | smarlowe | UTF8
yourdb | smarlowe | SQL_ASCII
The only thing you should need to reinitdb for is locale.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
