[ADMIN] localization problem

Hellou,can any1 point me to some tutorial what is needed to run localization support ...my problem is when i use order. Whole order is mismatch ...I have a debian linux with postgres 8.1.3 installed while searching the net i found some steps but probably it's not enougthat first locale -a output :C

[ADMIN] can i use to_ascii function ?

Hi i need to get rid of acute, and other special symbols from letters. Is any way how to do it easy in postgres ? i need conversion like this from slovak language ... : é, ě -> e á, ä -> a š -> s i tried : SELECT to_ascii('ščďť') i get an error : ERROR: encoding conversion from UTF8 to ASCI

[ADMIN] Fwd: localization, encoding problem

Hellou all   i have a problem to convert data from utf8 to ascii. I'm from slovakia and we use special characters like 'á é š ť' and so on. But many times it is the same if u use 'á' or 'a'. So I need to translate these special characters. Somebody told me to use function to_ascii() but this func

[ADMIN] localization, encoding problem

Hellou all   i have a problem to convert data from utf8 to ascii. My localization is slovakia and we use characters like 'á é š ť' and so on. But many times it is the same if u use 'á' or 'a'. Som I need to translate theese special characters. Somebody told me to use function to_ascii() but this f