Strictly speaking, Unicode is a whole family of code pages. Unicode generally means multi-byte character encoding. UTF-8 is the most common encoding implementation of Unicode at the moment. UTF-16 is also popular, but very few systems need that many characters or wish to devote that many bytes to each character. As far as PostgreSQL is concerned, "Unicode" is an alias for "UTF8", which is UTF-8 encoding. See: http://www.postgresql.org/docs/8.2/interactive/multibyte.html#MULTIBYTE- CHARSET-SUPPORTED -- Brandon Aiken CS/IT Systems Engineer -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Rob Tanner Sent: Monday, January 22, 2007 5:17 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: [GENERAL] Trouble creating database with proper encoding Hi, This is my first venture into PostgreSQL. I built and installer PostgreSQL 8.2.1 as part of a Xythos installation. I added a user called xythos and now I'm trying to add the initial databases that the product requires. From the command line, I executed the commands: createdb -U xythos -E UNICODE XythosDocumentStoreDB createdb -U xythos -E UNICODE XythosGlobalDB When I look at what I've done with psql -l, I get List of databases Name | Owner | Encoding -----------------------+----------+---------- XythosDocumentStoreDB | xythos | UTF8 XythosGlobalDB | xythos | UTF8 I dropped the databases and recreated them with unicode (lower case) but got the same results. I didn't see any special configure/compile options for character encoding, so what am I missing. Thanks. -- Rob Tanner UNIX Services Manager Linfield College, McMinnville OR -------------------------------------------------------------------- ** LEGAL DISCLAIMER ** Statements made in this email may or may not reflect the views and opinions of Wineman Technology, Inc. This E-mail message and any attachments may contain legally privileged, confidential or proprietary information. If you are not the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this E-mail message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this E-mail message from your computer. QS Disclaimer Demo. Copyright (C) Pa-software. Visit www.pa-software.com for more information.
