Re: Trouble creating database with proper encoding - Mailing list 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