Re: Trouble creating database with proper encoding

From: Tommy Gildseth <tommy(at)gildseth(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Trouble creating database with proper encoding
Date: 2007-01-22 22:38:15
Message-ID: 45B53CD7.2080800@gildseth.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brandon Aiken 2007-01-22 22:46:09 Re: Trouble creating database with proper encoding
Previous Message Rob Tanner 2007-01-22 22:17:22 Trouble creating database with proper encoding