On 6 Jul 2010, at 11:10pm, Ted Rolle, Jr. wrote: > The receiving field is defined as CHAR; [snip]
SQLite has no such type. Define the fields as TEXT instead: <http://www.sqlite.org/datatype3.html> Then try 'UPDATE UPCs SET UPC=043000205563;' and see what you get. > Last question: is this an example of SQLite's "typelessness"? SQLite has types. It just doesn't require every value in the same column to be of the same type. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
