On Tue, Apr 14, 2020 at 4:16 PM Troy wrote:
> The data in question was binary data, not unicode. It just happened to
> contain some valid UTF-8 sequences. I am communicating with the db
> through ODBC (64-bit), so I will have to look and see what is happening
> exactly. I will have to add some wor
The data in question was binary data, not unicode. It just happened to
contain some valid UTF-8 sequences. I am communicating with the db
through ODBC (64-bit), so I will have to look and see what is happening
exactly. I will have to add some workaround to make sure that the data
is added as a BLOB
On Sat, Apr 11, 2020 at 1:56 PM Troy Korjuslommi
wrote:
> Please note that in
> https://www.sqlite.org/lang_corefunc.html#length
>
> it says that "For a blob value X, length(X) returns the number of bytes
> in the blob."
Indeed, if that's a BLOB value. But as yourself noted: "when data is
valid U
Hi László,
Please note that in
https://www.sqlite.org/lang_corefunc.html#length
it says that "For a blob value X, length(X) returns the number of bytes
in the blob."
Troy
On Sat, 2020-04-11 at 09:15 +0200, László Böszörményi (GCS) wrote:
> Control: tags -1 +wontfix
>
> Hi Troy,
>
> On Thu,
Control: tags -1 +wontfix
Hi Troy,
On Thu, Apr 9, 2020 at 6:03 PM Troy Korjuslommi wrote:
> 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, no
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
6 matches
Mail list logo
