yogibabu <[email protected]> wrote: > I was wondering if there is a hex() function why shouldn't be dehex()
X'DEADBEEF' syntax is your "dehex". hex() takes a blob and produces a hex string. X'...' notation turns a hex string into a blob. If you want to convert a blob to text, there's CAST: select cast(X'303132' as text); 012 Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
