Skip site navigation (1) Skip section navigation (2)

Database encoding and Ctype

From: Fletcher Johnson <fjohnson(at)rotman-baycrest(dot)on(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Database encoding and Ctype
Date: 2011-04-19 14:54:10
Message-ID: 20110419105410.21fb365e.fjohnson@rotman-baycrest.on.ca (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)rotman-baycrest(dot)on(dot)ca>

pgsql-novice by date

Next:From: PyrogergDate: 2011-04-19 14:56:44
Subject: Re: MDTFATAL: could note create log file . . . permission denied
Previous:From: Grzegorz SzpetkowskiDate: 2011-04-19 12:00:42
Subject: Re: [ADMIN] "postgres" is needed by initdb but was not found

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group