Mysql Quotes, Double Quotes Mess

I'm trying to insert content into a MySQL and it looks like that: table name is foo and the columns are: id INTEGER, name VARCHAR(50), content VARCHAR(255), url

Solution 1:

You can escape quotes with backslash:

insertinto foo (id,name,content,url) values (0, 'test123', '<div id=\'test\'>ת"\א היא עיר מצוינת</div>', 'http://www.cnn.com')

You can also use the opposite kind of quotes:

insertinto foo (id,name,content,url) values (0, 'test123', "someContent's", 'http://www.cnn.com')

Here's how to do it with WebSQL parameterized queries:

transaction.executeSQL('INSERT INTO foo (id, name, content, url) VALUES (?, ?, ?, ?)',
    [0, 'test123', '<div id=\'test\'>ת"\א היא עיר מצוינת</div>', 'http://www.cnn.com'],
    callbackfn);

Solution 2:

You escape any string only for what's around it. So if you want to put double quotes around this one, you have to protect only the double quote inside.

Solution 3:

You can escape a quote using \ also known as the escape character. Have a look at this page that showcases the available escape sequences.

Solution 4:

try this :

insertinto foo (id,name,content,url) values (0,'test123','someContent\'s','http:\/\/www.cnn.com')