Hello, Changes related to convert* functions in postgresql 8.3 has impact on to_ascii function.
Before 8.3 I could do: postgres=# select to_ascii(convert('Příliš žlutý kůň' using utf8_to_iso_8859_2),'latin2'); to_ascii ------------------ Prilis zluty kun (1 row) but convert_to function return bytea now, and I can't to call it without unwanted changes in content of translated text. postgres=# SELECT to_ascii(convert_to('Příliš žlutý kůň', 'latin2')::text,'latin2'); to_ascii --------------------------------------- P\370\355li\271 \276lut\375 k\371\362 (1 row) ugly hack for it: postgres=# create function to_ascii(bytea, name) returns text as 'to_ascii_encname' language internal; CREATE FUNCTION postgres=# postgres=# SELECT to_ascii(convert_to('Příliš žlutý kůň', 'latin2'),'latin2'); to_ascii ------------------ Prilis zluty kun (1 row) Regards Pavel Stehule -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers