Postgres Pro
Downloads
Home   >   mailing lists

Database encoding and Ctype - Mailing list pgsql-novice

From Fletcher Johnson
Subject Database encoding and Ctype
Date
Msg-id 20110419105410.21fb365e.fjohnson@rotman-baycrest.on.ca
Whole thread Raw
List pgsql-novice
Tree view 
For reference I am using postgres 8.4.

When I create a database and specify the encoding and collation why is it necessary to also set the Ctype?

Or alternatively when I set the collation and Ctype why do I need to set the encoding?

What is the difference between the Ctype and the encoding, and why are they both necessary?

Thanks.

--
Fletcher Johnson <fjohnson@rotman-baycrest.on.ca>

pgsql-novice by date:

Previous
From: Pyrogerg
Date:
Subject: Re: MDTFATAL: could note create log file . . . permission denied
Next
From: "Deka, Rajib IN MAA SL"
Date:
Subject: Database system identifier mismatch