On Thu, 15 Apr 2010 15:25:56 -0500, [email protected] said:
> sqlite does not enforce types/length, or uniqueness.
I understand about types/lengths, but the uniqueness part doesn't
match with what I'm seeing:
$ sqlite3 /dev/shm/test.db
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> create table mytable(text unique);
sqlite> insert into mytable values("mystring");
sqlite> insert into mytable values("mystring");
SQL error: column text is not unique
sqlite>
Keith
--
To unsubscribe, reply using "remove me" as the subject.
