Subject: bug#54591: 29.0.50; sqlite-select returns blob result as multibyte string

From: Eli Zaretskii <[email-masked]>
Date: Sat, 02 Apr 2022 17:22:54 +0300

> From: Lars Ingebrigtsen <[email-masked]>
> Cc: [email-masked],  [email-masked]
> Date: Sat, 02 Apr 2022 15:59:28 +0200
> 
> Eli Zaretskii <[email-masked]> writes:
> 
> > We could store unibyte strings as BLOBs, couldn't we?
> 
> As I've said, we don't know whether a column is a TEXT or a BLOB column.

When storing? we could ask the caller to specify that, or
automatically consider unibyte non-ASCII strings as BLOBs.

> And "store as BLOB" has no particular meaning -- internally in sqlite,
> there is no particular difference: Both are just a series of bytes, and
> you can put any bytes you want into the columns.

Of course; the question is how those bytes are interpreted.  The
Python examples shown up-thread show the way, I think.