On Thu, 15 Apr 2010 15:25:56 -0500, thade...@thadeusb.com 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.