From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Lars Ingebrigtsen Newsgroups: gmane.emacs.bugs Subject: bug#54591: 29.0.50; sqlite-select returns blob result as multibyte string Date: Sat, 02 Apr 2022 15:59:28 +0200 Message-ID: <878rsnlh6n.fsf@gnus.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> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="6608"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Cc: 54591@debbugs.gnu.org, fjas@grdm.no To: Eli Zaretskii Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Sat Apr 02 16:00:16 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 1naeIa-0001VL-B1 for geb-bug-gnu-emacs@m.gmane-mx.org; Sat, 02 Apr 2022 16:00:16 +0200 Original-Received: from localhost ([::1]:59074 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1naeIY-0003YX-Ml for geb-bug-gnu-emacs@m.gmane-mx.org; Sat, 02 Apr 2022 10:00:14 -0400 Original-Received: from eggs.gnu.org ([209.51.188.92]:43646) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1naeIO-0003YI-Jk for bug-gnu-emacs@gnu.org; Sat, 02 Apr 2022 10:00:06 -0400 Original-Received: from debbugs.gnu.org ([209.51.188.43]:52432) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1naeIN-00009E-09 for bug-gnu-emacs@gnu.org; Sat, 02 Apr 2022 10:00:03 -0400 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1naeIM-0007wW-Nr for bug-gnu-emacs@gnu.org; Sat, 02 Apr 2022 10:00:02 -0400 X-Loop: help-debbugs@gnu.org Resent-From: Lars Ingebrigtsen Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Sat, 02 Apr 2022 14:00: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.164890798230479 (code B ref 54591); Sat, 02 Apr 2022 14:00:02 +0000 Original-Received: (at 54591) by debbugs.gnu.org; 2 Apr 2022 13:59:42 +0000 Original-Received: from localhost ([127.0.0.1]:46329 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1naeI2-0007vX-Cb for submit@debbugs.gnu.org; Sat, 02 Apr 2022 09:59:42 -0400 Original-Received: from quimby.gnus.org ([95.216.78.240]:49212) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1naeI0-0007vI-33 for 54591@debbugs.gnu.org; Sat, 02 Apr 2022 09:59:40 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnus.org; s=20200322; h=Content-Type:MIME-Version:Message-ID:In-Reply-To:Date: References:Subject:Cc:To:From:Sender:Reply-To:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=3tEDSrlZqZHXss3nt7PRdFcHYhajnfkztWVYzgxPn4E=; b=lXUA3U7YiyQzZslBWwvfJqLVuE DrfJd0+iRwxgf9aKnXBTl5+9jEe+FIX3oIpQk89aZNhVA4AABjjVCR+89pEnuKD31mb+jqjOsuUNT +XgLArk2VNPPR7SIsBU/us1UgE/OZW/9WJmNK6gHWMlDBiENyRY1g64LPTD6XwZ4rMtM=; Original-Received: from [84.212.220.105] (helo=xo) by quimby.gnus.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1naeHq-0005yJ-CU; Sat, 02 Apr 2022 15:59:32 +0200 Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAMAAABg3Am1AAAABGdBTUEAALGPC/xhBQAAACBj SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAAM1BMVEX+/v7s6Off1NCw qKpGLzZlWl/ZxLudkZGFeYIlGyWPaWTIsqoaEhcQCA0vKDMiFx3///8hP2MuAAAAAWJLR0QQlbIN LAAAAAd0SU1FB+YEAg03JPec68IAAAEjSURBVEjH7VbRjsMgDIOEJKOQ8P9/e6Gs7U5lnU73sJe6 0lZUGzueRBfCNxCfgK+437hx48ZvxL/RMSXiQyzI1xsgPVyxcZhSPlZTiAQA3E7IBYFS4isBo5+o ewrBEMty6RC5QNm3LAsDXBqECP3QPuSvqzeKTtpXwOVTy4UjHyFQlnL5jmCiwiXRIHlFrhfCdy5I VSlCMc1JolhVwwKk1WQq8Sc1ZyHLraqaam3NKFuurpx1ZbX5RdgZzukf+RHQ+rfSpJ/+xAXRWt2Q KUBa5RMBrJQeYudXS9ENdS5A7Ylazq8CQ7HVwc5jk65Rmo88BugdmHcwBGeHpM/cg6velFtQF/S7 8+9nY4Z6jLxmSiOh4qkk32cCb3RAzkNf4x9/O34AeBkPlLrBHzcAAAAldEVYdGRhdGU6Y3JlYXRl ADIwMjItMDQtMDJUMTM6NTU6MzYrMDA6MDAW4F+UAAAAJXRFWHRkYXRlOm1vZGlmeQAyMDIyLTA0 LTAyVDEzOjU1OjM2KzAwOjAwZ73nKAAAAABJRU5ErkJggg== X-Now-Playing: Pet Shop Boys's _Actually_: "Rent" In-Reply-To: <83h77b4mq0.fsf@gnu.org> (Eli Zaretskii's message of "Sat, 02 Apr 2022 16:51:51 +0300") 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:229266 Archived-At: 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. 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. > We could refrain from decoding BLOBs, couldn't we? Yes, I think I said so? -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no