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: Sun, 27 Mar 2022 09:40:29 +0300 Message-ID: <83h77jaof6.fsf@gnu.org> References: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="34531"; mail-complaints-to="usenet@ciao.gmane.io" Cc: 54591@debbugs.gnu.org To: Yuan Fu Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Sun Mar 27 08:41:22 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 1nYMaY-0008ty-0C for geb-bug-gnu-emacs@m.gmane-mx.org; Sun, 27 Mar 2022 08:41:22 +0200 Original-Received: from localhost ([::1]:33404 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nYMaV-0007kd-UU for geb-bug-gnu-emacs@m.gmane-mx.org; Sun, 27 Mar 2022 02:41:20 -0400 Original-Received: from eggs.gnu.org ([209.51.188.92]:53636) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nYMaE-0007jD-23 for bug-gnu-emacs@gnu.org; Sun, 27 Mar 2022 02:41:02 -0400 Original-Received: from debbugs.gnu.org ([209.51.188.43]:32971) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1nYMaD-000470-PU for bug-gnu-emacs@gnu.org; Sun, 27 Mar 2022 02:41:01 -0400 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1nYMaD-0002Xi-Le for bug-gnu-emacs@gnu.org; Sun, 27 Mar 2022 02:41:01 -0400 X-Loop: help-debbugs@gnu.org Resent-From: Eli Zaretskii Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Sun, 27 Mar 2022 06:41:01 +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.16483632379733 (code B ref 54591); Sun, 27 Mar 2022 06:41:01 +0000 Original-Received: (at 54591) by debbugs.gnu.org; 27 Mar 2022 06:40:37 +0000 Original-Received: from localhost ([127.0.0.1]:55101 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1nYMZp-0002Wv-9N for submit@debbugs.gnu.org; Sun, 27 Mar 2022 02:40:37 -0400 Original-Received: from eggs.gnu.org ([209.51.188.92]:37608) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1nYMZo-0002Wi-2S for 54591@debbugs.gnu.org; Sun, 27 Mar 2022 02:40:36 -0400 Original-Received: from [2001:470:142:3::e] (port=39674 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 1nYMZi-0003yl-Qq; Sun, 27 Mar 2022 02:40:30 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org; s=fencepost-gnu-org; h=MIME-version:References:Subject:In-Reply-To:To:From: Date; bh=5FpXj9XRmCQhv+9AzoUOuze/Iff6aBMrvvLM7eOq/Lk=; b=iINFIyOFEFaqMbLunVfC RI0tCqdKjfDN/L8UJaGx9uln4uhtAj4chJfLE4Gp84E5fYfHKNvjwoun3wBLqwpQLzcGqXWMGZd+n btZJymK0P1HPVM4q4E3Pb0xAXkoZUI3/2L8ZmDghlLlnojsLoh+RJs80wmXT0Zc2XXTrZ3hWZbm5x uFrUW6cUareI0cVpq1Xkr/UFHO32muqGmRHuxN9p7jDq1Z1j52UU9iN1hbmhci67cJE7NbIKMwDdV TchyW4xvm482mlGq+6keT585DnRpNyD+O7WDQU82LaoPdGzD/yZpb9HNUP8Tn7KQ65dTKrKBgn3aB iNnEsHe+Lxr8uQ==; Original-Received: from [87.69.77.57] (port=1629 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 1nYMZi-000103-Aa; Sun, 27 Mar 2022 02:40:30 -0400 In-Reply-To: (message from Yuan Fu on Sat, 26 Mar 2022 22:49:21 -0700) 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:228989 Archived-At: > From: Yuan Fu > Date: Sat, 26 Mar 2022 22:49:21 -0700 > > > I’m trying make use of sqlite functionalities added recently and found > that the query result of blob type entries are multibyte string rather > than unibyte. That caused issues when I tried to create image out of the > query result: the image appears to be broken, even though the data is > good. Adding string-as-unibyte solves the issue, but I guess the > return value of a blob entry is probably best to be unibyte by default? If we want to support non-text data in a blob, then yes, I think you are right.