Get the latest tech news

Nul Characters in Strings in SQLite


ows NUL characters (ASCII 0x00, Unicode \u0000) in the middle of string values stored in the database. However, the use of NUL within strings can lead to surprising behaviors: The length() SQL function only counts characters up to and excluding the first NUL.

None

Get the Android app

Or read this on Hacker News

Read more on:

Photo of strings

strings

Photo of nul characters

nul characters

Related news:

News photo

This TCL Mini LED TV is one of the best I've tested - and it's up to $2,000 off at Best Buy

News photo

Physicist Astrid Eichhorn is a leader in the field of asymptotic safety

News photo

Oregon gave homeless youth $1k/month with no strings. Here's what happened