On 2/17/16, Glyn Jones <glynj at bsquare.com> wrote:
> I set the schema to TEXT, but that apparently makes no difference!
>
> I'm using the TCL interface:
>
> set id "???"
> db eval {insert into users (id, name) values (:id, :name)}
>
When I run this script:
sqlite3 db :memory:
db eval {CREATE TABLE users(id,name);}
set id "???"
set name whatever
db eval {insert into users (id, name) values (:id, :name)}
puts [db eval {SELECT hex(id) FROM users}]
The output I see is "C2ACC2ACC2AC", not "C382C2ACC382C2ACC382C2AC".
--
D. Richard Hipp
drh at sqlite.org
