2 ms·
Wait until you read about its quirks [0]. My favorite: “NUL characters (ASCII code 0x00 and Unicode \u0000) may appear in the middle of strings in SQLite. This
by sgarland 3mo ago
Wait until you read about its quirks [0]. My favorite:
“NUL characters (ASCII code 0x00 and Unicode \u0000) may appear in the middle of strings in SQLite. This can lead to unexpected behavior.”
0: https://sqlite.org/quirks.html https://sqlite.org/quirks.html
- wvenable 3mo agoI was going to say that really shouldn't be a problem but then I read further: https://sqlite.org/nulinstr.html https://sqlite.org/nulinstr.html
- cowboylowrez 3mo agoYeah the fact that length() can't count null containing strings accurately is interesting.