On 3/4/08, John Elrick <[EMAIL PROTECTED]> wrote: > P Kishor wrote: > > 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. > > > SQLite doesn't care. I can testify from experience that some of the > Delphi wrappers DO care and artificially enforce the VARCHAR length. >
I think that was the point of my saying, "Anything using SQLite is free to do what it wants." I routinely write Perl code that checks what I am inserting into SQLite and croaks if something is not as I expected. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users