SQLite Supports NUL Characters Inside Text Strings

SQLite's official documentation explains how the database engine handles NUL characters (null bytes) embedded within text strings. While SQLite stores such strings correctly internally, certain API layers may truncate the text at the NUL byte, potentially causing subtle bugs in applications that rely on those interfaces.