[sqlite] what's the escape-character in sqlite?

i want to insert text with ' and " included. such as, insert into mytable (mytext) values( ' \' hello\' ' ) , or ("\"hello\"") .both give errors. is \ not an escape-character? then what is? thanks in advance.:) - To

[sqlite] what's the character limit of a single sql in sqlite?

could i use a long,long sql sentence to insert many items into a table once without limit? or there IS a limit so i have to accomplish it by doing it for multi times? thanks in advance.:) - To unsubscribe, e-mail: [EMAIL

[sqlite] typeless in sqlitedataset?

i'm using sqlitedataset (http://sqlitedataset.sourceforge.net/cms/) for c++ programming. when i use function get_fType() to retrieve the filed_value datatype, it always is 0,which means string. is there a problem? and how could i tell the 1 is char "1" or integer 49?