News for hackers. Stuff that matters.

A comment on Writing a SQLite clone from scratch in C. Parent comment

Re:Writing a SQLite clone from scratch in C by anton_gogolev on Tuesday September 05, 2017 @10:45AM (#15175680)
> ...every single quote...

And then you come across \u0027 and you're screwed.

[ Parent | on HN ]
Re:Writing a SQLite clone from scratch in C by wruza on Tuesday September 05, 2017 @06:41PM (#15179688)
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.

[ Parent | on HN ]
Re:Writing a SQLite clone from scratch in C by icebraining on Tuesday September 05, 2017 @11:01AM (#15175866)
If you use a broken RDBMS, maybe. The standard is quite clear, and that certainly doesn't work in PortgreSQL.
[ Parent | on HN ]