I see sqlite doesn't recognize the \ (backslash) as the backslash character, instead sqlite considers it as a normal character infact if I insert data into a field like: insert into table1 values('pippo\\pluto') sqlite inserts the value as: pippo\\pluto while other database (PostgreSQL, MySQL, BerkeleyDB) insert it as: pippo\pluto
Seems such behavior is conform to the SQL standard.
Testing on a small selection of databases and then assuming it's the standard is always a mistake.
The backslash is just another character in the SQL standard, it's PostgreSQL, MySQL and BerkeleyDB that have 'extended' the standard.
This has been talked about before on the previous YahooGroups portion of the list - drh himself started a discussion with this message: http://groups.yahoo.com/group/sqlite/message/4077
Jeff
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
