SQLite Escape Characters

02.13.06 - 11:27pm
mood: meh
 
Here's a tip to save someone two hours of wasted time.
SQLite does not support backslash character escaping. In PHP you can use the sqlite_escape_string() function to escape naughty characters, but you better as hell not think that \' will do anything... so much wasted time.