locales and MB (was: Postgres 6.5 beta2 and beta3 problem) - Mailing list pgsql-hackers

From Goran Thyni
Subject locales and MB (was: Postgres 6.5 beta2 and beta3 problem)
Date
Msg-id 3760B4A5.17BDB747@kirra.net
Whole thread Raw
In response to Re: [HACKERS] Postgres 6.5 beta2 and beta3 problem  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: locales and MB (was: Postgres 6.5 beta2 and beta3 problem)
RE: [HACKERS] locales and MB (was: Postgres 6.5 beta2 and beta3
List pgsql-hackers
Tatsuo Ishii wrote:
> I think until NATIONAL CHARACTER is fully implemented, we would not be
> able to properly handle sort orders with multi-byte characters.
> (Thomas, I've been think about implementing NCHAR too!)
> 
> So you could do whatever you like as long as they are in #ifndef
> MULTIBYTE:-)

Hmm,
and the world is moving towards Unicode.
we definitely need working support for locales and multichar.
Perhaps the right way to do it is to store everything in
som Unicode format internally and convert the output
according to the suggested "per-column-locale-definition".

Larry Wall has hacked UTF8 support into perl so it is doable,
so let see what we can do for 6.6 (time permitting as always).

regards,
Göran


pgsql-hackers by date:

Previous
From: bse@games.global.co.za
Date:
Subject: Crash on select?
Next
From: Daniel Kalchev
Date:
Subject: Re: [HACKERS] another locale problem