Re: Sorting Problem

From: Kathy zhu <Kathy(dot)zhu(at)Sun(dot)COM>
To: gearond(at)cvc(dot)net
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Tim Edwards <mor4321(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Sorting Problem
Date: 2003-08-12 23:43:11
Message-ID: 3F397B8F.2060109@Sun.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 Maksim Likharev 2003-08-12 23:54:32 Re: Sorting Problem
Previous Message Joshua D. Drake 2003-08-12 23:43:10 Re: PostGreSQL - Accessing It