Hacker News new | ask | show | jobs
by anton_gogolev 3212 days ago
> ...every single quote...

And then you come across \u0027 and you're screwed.
2 comments
wruza 3212 days ago
Do you know any decent server that interprets 6-char \uxxxx sequences as part of its top-level query syntax? I mean, how do you safely pass '\u0027' literal to it anyway? If you can't, then its literals and escaping are broken by design, so it is good to know from the start of using it.

Edit: removed double backslash from literal to not confuse it with host language's escaping.

link
icebraining 3212 days ago
If you use a broken RDBMS, maybe. The standard is quite clear, and that certainly doesn't work in PortgreSQL.
link