Re: String encoding during connection "handshake" - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: String encoding during connection "handshake"
Date
Msg-id 20071128164030.GF31742@svana.org
Whole thread Raw
In response to Re: String encoding during connection "handshake"  (sulfinu@gmail.com)
Responses Re: String encoding during connection "handshake"  ("Trevor Talbot" <quension@gmail.com>)
List pgsql-hackers
On Wed, Nov 28, 2007 at 05:54:05PM +0200, sulfinu@gmail.com wrote:
> Regarding the problem of "One True Encoding", the answer seems obvious to me:
> use only one encoding per database cluster, either UTF-8 or UTF-16 or another
> Unicode-aware scheme, whichever yields a statistically smaller database for
> the languages employed by the users in their data. This encoding should be a
> one time choice! De facto, this is already happening now, because one cannot
> change collation rules after a cluster has been created.

Umm, each database in a cluster can have a different encoding, so there
is no such thing as the "cluster's encoding". You can certainly argue
that it should be a one time choice, but I doubt you'll get people to
remove the possibilites we have now. If fact, if anything we'd probably
go the otherway, allow you to select the collation on a per
database/table/column level (SQL complaince requires this).

This has nothing to do with C by the way. C has many features that
allow you to work with different encodings. It just doesn't force you
to use any particular one.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [pgsql-www] Time to update list of contributors
Next
From: Dave Page
Date:
Subject: Re: [pgsql-www] Time to update list of contributors