Hi all,
If I have a text column, insert text into it, the ask SQLite for the
insert statement, shouldn't it show a text result? SQLite appears to
coerce it to a number if it can, but shouldn't.
Here's an example:
.mode insert
create temp table "Test" (MyString text);
insert into Test values (123);
insert into Test values ('456');
insert into Test values ('789x');
select * from Test;
should give what I put in, ie:
insert into Test values (123);
insert into Test values ('456');
insert into Test values ('789x');
but it instead gives:
INSERT INTO table VALUES(123);
INSERT INTO table VALUES(456);
INSERT INTO table VALUES('789x');
The 456 value seems incorrect. It should show a literal '456', not a
number.
Is this a bug?
I'm using SQLite 3.6.11 on Mac OS X.
Thanks,
Tom
BareFeet
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
