Re: UTF-8 - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: UTF-8
Date
Msg-id 20061012084942.GA11723@svana.org
Whole thread Raw
In response to Re: UTF-8  (Martins Mihailovs <martins.mihailovs@europrojects.org>)
Responses Re: UTF-8  ("Tomi NA" <hefest@gmail.com>)
List pgsql-general
On Tue, Oct 10, 2006 at 11:49:06AM +0300, Martins Mihailovs wrote:
> There are some misunderstood. Im using Linux 2.6.16.4, postgresql 8.1.4,
> (there are one of locale:   lv_LV.utf8, for Latvian language). But if I
> want do "lower", then with standard latin symbols all is ok, but with
> others special symbols (like umlaut in Germany) there is problems, and
> sorting is going not like alphabet but like latin alphabet and specials
> symbols after. :(

You don't say what your encoding is. If it not UTF-8, that's your
problem...

Check the lc_collate, lc_ctype and encoding settings and make sure
they're compatable with eachother.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Chris Mair
Date:
Subject: Re: more anti-postgresql FUD
Next
From: "Dawid Kuroczko"
Date:
Subject: Re: more anti-postgresql FUD