On 28 Sep 2010, at 3:13am, Hemant Shah wrote: > The MD5Sum column is char[33], the sum is 32 characters long, the C datatype > is also char[33] (i.e. one extra character for NULL termination).
Please note that SQLite completely ignores any character length restrictions you may have specified. The only types SQLite understands are those listed here: http://www.sqlite.org/datatype3.html and as you can see your 'char[33]' specification will be understood as 'TEXT'. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users