1 2 3 4 5 6 7 8
CREATE TABLE t1(x INT, y REAL); INSERT INTO t1 VALUES('1234','4567'),('0x1234','0x4567'); SELECT typeof(x), x, typeof(y), y, '#' FROM t1 ORDER BY rowid; SELECT CAST('0x1234' AS INTEGER);