I have a column defined as TEXT and I insert utf-8 text into it. In particular,
there are byte sequences that might look as follows:
... 74 6F 20 C2 A3 32 35 30 ... (in hex)
which represents:
... to £250 ...
I used Navicat for SQLite Lite to peer at the data as hex and text in the
column, and it looks as I've presented it.
The problem comes when I try to retrieve the data using a PHP script. I want
the data back as bytes because I'm going to encode it as quoted printable, with
decimal byte values greater than 127 being separately encoded. This would give
the above as:
... to =C2=A3250 ...
But: the byte stream I get back on doing a SELECT is always *missing* the C2
byte. What am I missing here? I'm using the PHP PDO interface.
Thanks,
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users