Comments on: Quoting text JavaScript/Python style https://shlomi-noach.github.io/blog/mysql/quoting-text-javascriptpython-style Blog by Shlomi Noach Thu, 17 Nov 2011 20:19:11 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Roland Bouman https://shlomi-noach.github.io/blog/mysql/quoting-text-javascriptpython-style/comment-page-1#comment-59245 Thu, 17 Nov 2011 20:19:11 +0000 https://shlomi-noach.github.io/blog/?p=4364#comment-59245 Actually, to the best of my knowledge, the standard way to escape single quotes is by using two single quotes. I don’t think there are any other escapes

(I should check what it says on characters like \t\f\r\n etc. I think you’re supposed to enter them literal, as is in standard SQL)

]]> By: Daniël van Eeden https://shlomi-noach.github.io/blog/mysql/quoting-text-javascriptpython-style/comment-page-1#comment-59058 Wed, 16 Nov 2011 09:23:00 +0000 https://shlomi-noach.github.io/blog/?p=4364#comment-59058 String escaping between MySQL and PostgreSQL is unfortunately not very compatible. As of PostgreSQL 9.1 standard_conforming_strings is on by default. Which means you have to use E’some string with backslash escapes.’ which is not supported in MySQL. So much for SQL standards and different implementations…

]]>