Re: Sorting Problem - Mailing list pgsql-general

From Kathy
Subject Re: Sorting Problem
Date
Msg-id 3F39C770.5050204@sun.com
Whole thread Raw
In response to Re: Sorting Problem  ("Maksim Likharev" <mlikharev@aurigin.com>)
List 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.zhu@Sun.COM]
>Sent: Tuesday, August 12, 2003 4:43 PM
>To: gearond@cvc.net
>Cc: Tom Lane; Tim Edwards; pgsql-general@postgresql.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@cvc.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
>>
>>
>
>
>
>


pgsql-general by date:

Previous
From: Jerome Macaranas
Date:
Subject: Viewing Client Connections..
Next
From: "Joshua D. Drake"
Date:
Subject: Re: PostGreSQL - Accessing It