Carlos Moreno <[EMAIL PROTECTED]> writes:
> ... The one that does the case conversion "correctly" (read: as I
> expect it as per Spanish or French rules) is 8.1.4 with en_US locale
> (LC_CTYPE and LC_COLLATE both showing en_US.UTF-8). PG 7.4.14, *even
> with locale es_ES*, does not do the case con
On Wed, Nov 01, 2006 at 08:50:30PM +0100, Martijn van Oosterhout wrote:
> > Could this paragraph be put into the docs and/or the FAQ,
> > please ? Along with the recommendation that if you require
> > multiple encodings for your databases you better had your OS
> > locale configured properly for U
On Wed, Nov 01, 2006 at 11:41:43AM +0100, Karsten Hilbert wrote:
> Could this paragraph be put into the docs and/or the FAQ,
> please ? Along with the recommendation that if you require
> multiple encodings for your databases you better had your OS
> locale configured properly for UTF8 and use UNIC
Karsten Hilbert <[EMAIL PROTECTED]> writes:
> Could this paragraph be put into the docs and/or the FAQ,
> please ?
Section 21.2. Character Set Support already has something about it:
Important: Although you can specify any encoding you want for a
database, it is unwise to choose an enco
Thanks Tom, for your reply.
Tom Lane wrote:
Carlos Moreno <[EMAIL PROTECTED]> writes:
Why is it that the database
cluster is resrticted to a single locale (or single set of locales) instead
of being configurable on a per-database basis?
Because we depend on libc's locale support, wh
On Tue, Oct 31, 2006 at 11:47:56PM -0500, Tom Lane wrote:
> Because we depend on libc's locale support, which (on many platforms)
> isn't designed to switch between locales cheaply. The fact that we
> allow a per-database encoding spec at all was probably a bad idea in
> hindsight --- it's out fr
Carlos Moreno <[EMAIL PROTECTED]> writes:
> Why is it that the database
> cluster is resrticted to a single locale (or single set of locales) instead
> of being configurable on a per-database basis?
Because we depend on libc's locale support, which (on many platforms)
isn't designed to switch betw
Hi,
Even though I *think* I have a fairly clear understanding of encoding
and locale principles, I'm somewhat unsure of how some of the tools
available with PostgreSQL apply (or rather, how should they be used).
1) The way I understand it, encoding (character set) and locale are two
different
