Tomasz Rejman wrote: > Few days ago I have changed my postgreSQL to 8.3 version and I have problem > with bytea fields. Let me show you an example: > > CREATE TABLE testtable > ( > test bytea > ); > insert into testTable (test) VALUES > (E'\304\205\304\207\305\274\303\263\305\202wjfdsafdsa'); > select encode(test, 'escape') from testTable; > > In the previous version last Select will display exact characters in UTF8 > encoding (some polish letters with dot-s and comma-s on them), but in 8.3 > i'm getting an escaped string with byte codes (like this one in Insert > querry) > > (correct data should be like that: > select E'\304\205\304\207\305\274\303\263\305\202wjfdsafdsa'; > ) > > What should I do to tell the postgreSQL to unescape that data? select convert_from(test, 'UTF8') from testTable; Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
