Search Postgresql Archives

Trouble creating database with proper encoding

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux