Postgres Pro
Downloads
Home   >   mailing lists

how do I create a db with unicode encoding on a utf8 server - Mailing list pgsql-admin

From Jessica Richard
Subject how do I create a db with unicode encoding on a utf8 server
Date
Msg-id 20061128113453.34441.qmail@web58309.mail.re3.yahoo.com
Whole thread Raw
List pgsql-admin
Tree view
I have a Postgre server with UTF8 as the default encoding. I am trying to create a new database on this same server  with UNICODE encoding so that I can load an UNICODE database from another server. No matter how I specify unicode option on this utf8 server, it just  created a utf8 db for me any way. Can different databases have different encodings on the same server? I remember they could before....

Thanks,
Jessica

Want to start your own business? Learn how on Yahoo! Small Business.

pgsql-admin by date:

Previous
From: Peter Wilson
Date:
Subject: Problem restoring with pg_dump
Next
From: Jessica Richard
Date:
Subject: how do I load a 8.0.8 database with unicode encoding into 8.1.4/utf8?