On https://sqlite.org/lang_expr.html under "Literal Values (Constants)", I read:
Hexadecimal integer literals follow the C-language notation of "0x" or "0X" followed by hexadecimal digits. For example, 0x1234 means the same as 4660... However, this doesn't seem to work for me: sqlite> select 12; 12 sqlite> select 0x12; Error: unrecognized token: "0x12" Am I doing sometihng wrong? Or is this a feature that is newer than Ubuntu 14.04's bundled sqlite3, which is 3.8.2? -Ketil