Hello I thought that SQLite treated any numeric data the same, but some Delphi components seem to handle TEXT data as BLOB/MEMO, and handle VARCHAR as regular text:
http://img404.imageshack.us/img404/8614/nextdbgridparentzt9.jpg http://img246.imageshack.us/img246/6615/delphismdbgrid1hw8.jpg I'd like to know if there are drawbacks to switching from TEXT to (VAR)CHAR? I'd rather not have to specify the maximum length of text items because I usually don't know how bit they might be. Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users