Package: libsqlite3-dev Version: 3.27.2-3 Severity: important
The LENGTH() function should return the number of bytes for a column of type BLOB (according to sqlite3 documentation). However, when data is valid UTF-8, it returns the number of characters, not bytes. This means that LENGTH(column) is less than the number of actual bytes returned from SELECT. -- System Information: Debian Release: 10.3 APT prefers stable-updates APT policy: (500, 'stable-updates'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 4.19.0-8-amd64 (SMP w/4 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages libsqlite3-dev depends on: ii libc6-dev 2.28-10 ii libsqlite3-0 3.27.2-3 libsqlite3-dev recommends no packages. Versions of packages libsqlite3-dev suggests: ii sqlite3-doc 3.27.2-3 -- no debconf information