Sorry for the newbie SQL question. I'm trying to use the INSERT INTO
statement with a hexadecimal literal. I want to accomplish something
like this:
INSERT INTO TruckDefaultsTable VALUES ( 'AirPressureTime', 0, 0xB40000);
sqlite chokes on the 0xB40000 expression with:
unrecognized token: "0xB40000"
I could express the value in decimal as 11796480, but that's pretty awkward
since the actual value I'm putting into the table is a Linux timeval structure.
It just makes more sense as hex.
Does SQL have a hex literal sequence that serves the same role as "0x" in C?
Thanks for any help.
Ben
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
