From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Eli Zaretskii Newsgroups: gmane.emacs.bugs Subject: bug#54591: 29.0.50; sqlite-select returns blob result as multibyte string Date: Sat, 02 Apr 2022 17:22:54 +0300 Message-ID: <83ee2f4la9.fsf@gnu.org> References: <83h77jaof6.fsf@gnu.org> <87lewsakng.fsf@gnus.org> <83o81o93ak.fsf@gnu.org> <87a6d672xr.fsf@gnus.org> <878rso7iuu.fsf@flokut.localdomain> <87v8vrljyu.fsf@gnus.org> <83h77b4mq0.fsf@gnu.org> <878rsnlh6n.fsf@gnus.org> Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="40699"; mail-complaints-to="usenet@ciao.gmane.io" Cc: 54591@debbugs.gnu.org, fjas@grdm.no To: Lars Ingebrigtsen Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Sat Apr 02 16:23:31 2022 Return-path: Envelope-to: geb-bug-gnu-emacs@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1naef5-000AQX-6v for geb-bug-gnu-emacs@m.gmane-mx.org; Sat, 02 Apr 2022 16:23:31 +0200 Original-Received: from localhost ([::1]:37922 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1naef3-0001Hu-IQ for geb-bug-gnu-emacs@m.gmane-mx.org; Sat, 02 Apr 2022 10:23:29 -0400 Original-Received: from eggs.gnu.org ([209.51.188.92]:47966) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1naeec-0001F9-V2 for bug-gnu-emacs@gnu.org; Sat, 02 Apr 2022 10:23:02 -0400 Original-Received: from debbugs.gnu.org ([209.51.188.43]:52493) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1naeec-0003fx-Mj for bug-gnu-emacs@gnu.org; Sat, 02 Apr 2022 10:23:02 -0400 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1naeec-0002JD-Fo for bug-gnu-emacs@gnu.org; Sat, 02 Apr 2022 10:23:02 -0400 X-Loop: help-debbugs@gnu.org Resent-From: Eli Zaretskii Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Sat, 02 Apr 2022 14:23:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 54591 X-GNU-PR-Package: emacs Original-Received: via spool by 54591-submit@debbugs.gnu.org id=B54591.16489093668843 (code B ref 54591); Sat, 02 Apr 2022 14:23:02 +0000 Original-Received: (at 54591) by debbugs.gnu.org; 2 Apr 2022 14:22:46 +0000 Original-Received: from localhost ([127.0.0.1]:46390 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1naeeM-0002IY-Ew for submit@debbugs.gnu.org; Sat, 02 Apr 2022 10:22:46 -0400 Original-Received: from eggs.gnu.org ([209.51.188.92]:60216) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1naeeL-0002IL-8x for 54591@debbugs.gnu.org; Sat, 02 Apr 2022 10:22:45 -0400 Original-Received: from [2001:470:142:3::e] (port=47536 helo=fencepost.gnu.org) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1naeeF-0003ds-Li; Sat, 02 Apr 2022 10:22:39 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org; s=fencepost-gnu-org; h=References:Subject:In-Reply-To:To:From:Date: mime-version; bh=UTZRuOrpONe940aJ2yvSnBxfMRPXSMrJ8Xxg1sg2BsI=; b=qbl78/akhu2Y JcGQHiUCrSkvLd3KaYtoi3FhhcpY9kPzscwmWH7Fepiz3t25GxvAcxNIx8jvslwqkwQ4EbkPbmMuN Wq46dWZR61vCTPc0QmgUgOc5s7pNhsJ96sNz9rjvLXEWUOEk7KrjO3y+oTfGkiXh+YRUtXzuYMc9r xBfT38TFH825GAYaZtmWtAmVkFUmlkoNCnsnC/BCIwT8SWfYdrEeVyit6cHgSqNVK3N59k0syVIYk KtouFxF6jKxCPNiY7ClhU6+NHW0DU4Kls3mXR70X7HOe1GdVjh+CT5r2tDuRMDXyV6P52/H/yNIGy AYEsjvELxU9QsNENtGv2ug==; Original-Received: from [87.69.77.57] (port=1369 helo=home-c4e4a596f7) by fencepost.gnu.org with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1naeeF-00019O-24; Sat, 02 Apr 2022 10:22:39 -0400 In-Reply-To: <878rsnlh6n.fsf@gnus.org> (message from Lars Ingebrigtsen on Sat, 02 Apr 2022 15:59:28 +0200) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-BeenThere: bug-gnu-emacs@gnu.org List-Id: "Bug reports for GNU Emacs, the Swiss army knife of text editors" List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Original-Sender: "bug-gnu-emacs" Xref: news.gmane.io gmane.emacs.bugs:229272 Archived-At: > From: Lars Ingebrigtsen > Cc: fjas@grdm.no, 54591@debbugs.gnu.org > Date: Sat, 02 Apr 2022 15:59:28 +0200 > > Eli Zaretskii 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.