Re: [HACKERS] Bytea misconceptions

2003-02-21 Thread Peter Eisentraut
Peter Eisentraut writes: Example: Create a cluster with non-C CTYPE, create a LATIN1 database, create a table with a bytea column, and store something with non-ASCII characters in it. Then change the client encoding (to UNICODE, say) and read the data. I stored 'ätsch bätsch' and got

Re: [HACKERS] Bytea misconceptions

2003-02-19 Thread Joe Conway
Peter Eisentraut wrote: In general, the only safe solution would be to escape *all* byte values on output. Then the client can reconstruct the byte sequence based on the character entities in the delivered string and does not have to rely on the character codes staying the same during the