Re: Sorting Problem

From: Kathy <kathy(dot)zhu(at)sun(dot)com>
To: Maksim Likharev <mlikharev(at)aurigin(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Sorting Problem
Date: 2003-08-13 05:06:56
Message-ID: 3F39C770.5050204@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Does including sorting rules for asian chars too ??
Do you know where I can find docuemt on this subject ??
thanks,
kathy

Maksim Likharev wrote:

>If you are talking about everything that lies under so called LATIN-1 (
>ISO-8859-1 )
>en_US encapsulates ( at least suppose to ) all those sorting rules,
>do not remember about accents tho.
>
>
>-----Original Message-----
>From: Kathy zhu [mailto:Kathy(dot)zhu(at)Sun(dot)COM]
>Sent: Tuesday, August 12, 2003 4:43 PM
>To: gearond(at)cvc(dot)net
>Cc: Tom Lane; Tim Edwards; pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] Sorting Problem
>
>
>This brings up another question:
>
>Say initdb with en_US locale, and we have localized strings for
>different
>languages store in the db.
>
>If we have a client in Germany, and want to see the text sorted in
>german. I
>mean that we want do db soring for german strings and display the result
>in the
>browser. How are we going to handle that ??
>
>thanks,
>kathy
>
>
>
>
>Dennis Gearon wrote:
>
>
>>Danke, Spacibo, gracias, thanks.
>>
>>Tom Lane wrote:
>>
>>
>>
>>>Dennis Gearon <gearond(at)cvc(dot)net> writes:
>>>
>>>
>>>
>>>>You mean in his own local environment? So all his programs, console
>>>>operations, etc, will have the new encoding? Or 'LANG/LC_ALL' for
>>>>Posgres specifically?
>>>>
>>>>
>>>
>>>I mean he needs to run initdb with C as the selected locale. It has
>>>nothing to do with what environment his other programs run in.
>>>
>>> regards, tom lane
>>>
>>>
>>>
>>---------------------------(end of
>>
>>
>broadcast)---------------------------
>
>
>>TIP 7: don't forget to increase your free space map settings
>>
>>
>
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2003-08-13 05:09:27 Re: PostGreSQL - Accessing It
Previous Message Jerome Macaranas 2003-08-13 05:03:55 Viewing Client Connections..