Re: [sqlite] How can I deal with hexadecimal numerical value?

2010-03-15 Thread Pavel Ivanov
If you need to insert integer value then you'll have to convert it to decimal notation by yourself. It's not a big deal, right? If you want to insert blob or text string with this byte/character in it then you can use notation like this:    select X'FF';    insert into t values(X'FF'); Pavel On

[sqlite] How can I deal with hexadecimal numerical value?

2010-03-15 Thread How can I deal with hex numerical value?
sqlite doesn't support 0xFF in SQL, such as: select 0xFF; insert into t values(0xFF); Error: unrecognized token: "0xFF" But sometime, this is not convenient. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/m