"flakpit" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I've been escaping single quote characters in all my text fields and > using the sqlite_execute function to put the data into the table. But > is it possible to use the prepare/bind commands to enter data so that > I don't have to do this?
Yes. > I've been using the column_text type to get back a block of text and > it's being truncated at the first CR/LF pair in the text block SQLite doesn't truncate anything. Either you truncated at the time you put the data into the database in the first place, or you are truncating now when looking at the string. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
