Hacker News new | ask | show | jobs
by sgarland 20 days 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

1 comments

I was going to say that really shouldn't be a problem but then I read further:

https://sqlite.org/nulinstr.html

Yeah the fact that length() can't count null containing strings accurately is interesting.