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

Reply via email to