On Thu, Mar 21, 2013 at 6:52 PM, Tim Streater <t...@clothears.org.uk> wrote:
> 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, > What do you get back when you do select "hex(column)" instead of just "column" using PHP. If the C2 byte is there, then I'm going to put the blame on PHP in this case. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
