Oleg Bartunov kirjutas E, 11.08.2003 kell 11:52: > On Mon, 11 Aug 2003, Peter Eisentraut wrote: > > > Alexey Mahotkin writes: > > > > > AFAIK, currently the codepoints are sorted in their numerical order. I've > > > searched the source code and could not find the actual place where this is > > > done. I've seen executor/nodeSort.c and utils/tuplesort.c. AFAIU, they > > > are generic sorting routines. > > > > PostgreSQL uses the operating system's locale routines for this. So the > > sort order depends on choosing a locale that can deal with Unicode. > > > > sort order works, but upper/lower are broken.
I think that the original MB/Unicode support was made for japanese language/characters, and AFAIK they don't even have the concept (problem) of upper/lower case. A question to the core - are there any plans to rectify this for less fortunate languages/charsets? Will the ASCII-speaking core tolerate the potential loss of performance from locale-aware upper/lower ? Will this be considered a feature or a bugfix (i.e. should we attempt to fix it for 7.4) ? --------------- Hannu ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
