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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Rob Tanner
Sent: Monday, January 22, 2007 5:17 PM
To: pgsql-general@postgresql.org
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
arenot 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
messagefrom your computer.
QS Disclaimer Demo. Copyright (C) Pa-software.
Visit www.pa-software.com for more information.