Try setting the variable lc_collate, either in an individual session
using SET or (to change it for all session) in postgresql.conf.
Craig Ringer wrote:
CK Leung wrote:
I create a new database use UTF-8 and SQL_ASCII, same result found, how
can i fix this problem ?
If
CK Leung wrote:
> I create a new database use UTF-8 and SQL_ASCII, same result found, how
> can i fix this problem ?
If I recall correctly, the collation order is set at initdb time, and
isn't bound to the database encoding. If that's right, you'd need to
dump all your databases, re-initdb with th
I create a new database use UTF-8 and SQL_ASCII, same result found, how
can i fix this problem ?
CK
Kevin Grittner wrote:
CK Leung wrote:
the result : select * from tt order by item_code;
item_code
--
V
.V
V.
VA.AAA
V.B
V
(V
>>> CK Leung wrote:
> the result : select * from tt order by item_code;
>
> item_code
> --
> V
> .V
> V.
> VA.AAA
> V.B
> V
> (V
> (V)
> (V)B.BBB
> (VB)BBB
> V.
> V)
> VCCC
> (13 rows)
>
> the sort sequence like ignore t
Andreas Seltenreich <[EMAIL PROTECTED]> writes:
>> Klaus Ita schrob:
>>> this is also wrong (There should be 'Unter' and then 'U:berflieger'
>>> [Überflieger]). so is this a libc bug?
> I think I got your point now. Libc appears to be using iso-14651
> sorting for all "de" locales. I'm afraid you
Sorry, I just reread your mail: Your MUA is declaring it with
> Content-Type: text/plain; charset=unknown-8bit
This makes it even harder to discuss problems with Umlauts :-).
Andreas Seltenreich schrob:
> Klaus Ita schrob:
>
>> another "funny" thing is:
>>
>> [EMAIL PROTECTED]:~/.mutt$ [EMAIL
Klaus Ita schrob:
> On Thu, Sep 01, 2005 at 09:30:15AM -0400, Tom Lane wrote:
>> Klaus Ita <[EMAIL PROTECTED]> writes:
>> > I have tried starting postgres with [EMAIL PROTECTED]
>> > locale but that did not help.
>>
>
> i did read the docs and am still not quite happy with my sorting results.
> o
On Thu, Sep 01, 2005 at 09:30:15AM -0400, Tom Lane wrote:
> Klaus Ita <[EMAIL PROTECTED]> writes:
> > I have tried starting postgres with [EMAIL PROTECTED]
> > locale but that did not help.
>
i did read the docs and am still not quite happy with my sorting results.
ok initdb has been rerun
made
Klaus Ita <[EMAIL PROTECTED]> writes:
> I have tried starting postgres with [EMAIL PROTECTED]
> locale but that did not help.
You need to run initdb under that setting. See "Localization" in
the documentation.
regards, tom lane
---(end of broadcas
