Craig Ringer wrote:
Yes - but you are *not* presenting a Latin-1 character. You're
presenting four Latin-1 characters:

  '\', '3', '7', '5'
Well, then I have a different question.  If I can view a bytea column as so:

> select object from context_objects where context_key=100041;
          object
-----------------------------
\005\007\021\007Article\003
(1 row)

How can I modify the data and put it back into the column?

I'm trying to track down while a ten year old system no longer works after a Perl DBI upgrade. Something is munging high LATIN1. The DB itself is UTF-8, client_encoding is set to LATIN1. We expect LATIN1 in, same stuff out. But right now that is what I'm debugging.


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to