>What about this:
>select name, length(name), hex(name)
>from PerfTest1
>where name like '%key5000%';
>hex(name) should dump raw bytes, in hexadecimal, stored in name column.
>See if there's anything unusual (perhaps a trailing NUL byte?)
Returns: 'key5000'|9|276B65793530303027
Nothing weird there. I feel stupid (and contagious) but I sure don't see
why this doesn't work!
Table structure is:
sqlite3 test.db 'create table PerfTest1 (name TEXT , value1 INTEGER,
value2 INTEGER,
value3 INTEGER, value4 INTEGER, value5 INTEGER, value6 INTEGER,
value7 INTEGER,
value8 INTEGER, value9 INTEGER, value10 INTEGER, value11 INTEGER,
value12 INTEGER,
value13 INTEGER, value14 INTEGER, value15 INTEGER, value16 INTEGER,
value17 INTEGER,
value18 INTEGER, value19 INTEGER, value20 INTEGER, value21 INTEGER,
value22 INTEGER,
value23 INTEGER, value24 INTEGER, value25 INTEGER, value26 INTEGER,
value27 INTEGER,
value28 INTEGER, value29 INTEGER, value30 INTEGER, value31 INTEGER,
value32 INTEGER,
value33 INTEGER, value34 INTEGER, value35 INTEGER, value36 INTEGER,
value37 INTEGER,
value38 INTEGER, value39 INTEGER, PRIMARY KEY(name, value1))'
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
