On 02/12/2010, at 6:39 PM, Janine Ohmer wrote: > On Dec 1, 2010, at 11:16 AM, Bernhard van Woerden wrote: >> Can you check the byte sequence of the string in the db that's causing a >> problem. > > Sort of... the column in question is of type text, and the only function I > can find that will convert from text to bytea is decode, not encode. So > here's what I did: > > select decode(answer_3, 'escape') from public_places where > public_place_id=1012; > > The interesting part of the result is "Park\302\222s", which is supposed to > be "Park's".
I don't know whether this is relevant or not, but 0x92 is "’" in the windows-1252 (aka "ISO-8859-1 (Windows)") encoding... cheers Russell -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <lists...@listserv.aol.com> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.