NUL Characters In Strings
- Introduction SQLite allows 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.
Unverified
- Introduction SQLite allows 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.
Sources: Sqlite