We’re launching Lyria 3.5 in Google Flow Music, with advances across musicality, lyrics, vocals, and creative control
deepmind.google·6d ago
AI Engineering
Hacker News·20d ago·5 min read
Nul Characters in Strings in SQLite
TL;DR
SQLite allows NUL characters in strings, but their presence can lead to unexpected behavior, such as incorrect length calculations. Functions like length() and quote() stop processing at the first NUL character, and the CLI's .dump command omits everything after it.
✦ Why It Matters
Avoid using NUL characters in SQLite strings to prevent data loss and unexpected behavior in your applications.
Key Takeaways
- Do not use NUL characters in SQLite strings.
- Use length() to check string lengths, but be aware of NULs.
- Utilize instr() to find embedded NUL characters in strings.
- Apply UPDATE statements to clean strings of NUL characters.
How It Works
SQLite processes strings with NUL characters differently, counting only up to the first NUL in functions like length() and quote(). This can lead to confusion when querying data, as the actual stored length may differ from what is displayed.