Trouble creating database with proper encoding

Rob Tanner wrote:

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.

Unicode in itself is just a standard. UTF-8 is one of the
implementations of this standard. So, your database is indeed created
with a unicode characterset

--
Tommy

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 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.