On 8/7/17, Simon Slavin <[email protected]> wrote: > Suppose I have a Unicode string stored in a TEXT field in a database. The > string might contain complicated Unicode compound characters, but it was > properly composed. By this I mean that the string is correctly > Unicode-encoded by Unicode-aware software and OS, with no mistakes about how > Unicode should be done. > > Can I persuade the SQLite shell tool to spit out the characters string in > Hex ? Perhaps by casting it to a BLOB ?
Use the hex() SQL function. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

