3 ms·
> ...every single quote... And then you come across \u0027 and you're screwed.
by anton_gogolev 9y ago
> ...every single quote...
And then you come across \u0027 and you're screwed.
- icebraining 9y agoIf you use a broken RDBMS, maybe. The standard is quite clear, and that certainly doesn't work in PortgreSQL.
- wruza 9y agoDo 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.