I think you have answered you question yourself. See below -- On 3/4/08, Gilles Ganault <[EMAIL PROTECTED]> wrote: > 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:
SQLite doesn't care. Anything using SQLite is free to do what it wants. > > 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. > Once again, SQLite doesn't care and will happily store a million character string in a TEXT (1) column. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users