locales and MB (was: Postgres 6.5 beta2 and beta3 problem)

From: Goran Thyni <goran(at)kirra(dot)net>
To: t-ishii(at)sra(dot)co(dot)jp
Cc: pgsql-hackers(at)postgresql(dot)org, Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Subject: locales and MB (was: Postgres 6.5 beta2 and beta3 problem)
Date: 1999-06-11 07:03:01
Message-ID: 3760B4A5.17BDB747@kirra.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Kalchev 1999-06-11 07:06:06 Re: [HACKERS] another locale problem
Previous Message bse 1999-06-11 06:18:15 Crash on select?