proposal: to_ascii(bytea)
От | Pavel Stehule |
---|---|
Тема | proposal: to_ascii(bytea) |
Дата | |
Msg-id | 162867790806260840q22419d28g2b2544cc47c94732@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: proposal: to_ascii(bytea)
|
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: