On Thu, Oct 12, 2006 at 11:09:53PM +0200, Tomi NA wrote: > 2006/10/12, Martijn van Oosterhout <kleptog@xxxxxxxxx>: > >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... > > Doesn't lv_LV.utf8 mean he *did* say what his encoding is? Not really. It says the encoding the system *expects*. However, if he actually created his database with LATIN1 encoding, it would explain the problems he's having. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
