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@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
