Thread: 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 function throws me an error : not supported encoding. There is about 50 characters that i need translate.  

 

OS  : debian

PostgreSQL : 8.1.3

configured with --enable-multibyte=UTF8