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 Mon, Mar 15, 2010 at 3:51 AM, How can I deal with hex numerical value? <zhangzheng...@126.com> wrote: > 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/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
