Hello all, I am trying to print some table values in hexadecimal. I've seen in the docs that there is a function called 'hex' but the following:
create table aa (a integer); insert into aa values(10); insert into aa values(11); insert into aa values(12); insert into aa values(13); insert into aa values(14); insert into aa values(15); select hex(a) from aa; results in: SQL error: no such function: hex while: select min(a) from aa; results in the correct answer: 10 I've seen in the source code that the function hex does indeed exist and it is inserted into the built in function table together with the min and a load of other functions. Before digging more into the sources, can you tell me if I am doing something stupid and how the function hex may be used? Or at least if it is possible to print hexadecimal values at all. Thanks all. Mau. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
