From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Po Lu via "Bug reports for GNU Emacs, the Swiss army knife of text editors" Newsgroups: gmane.emacs.bugs Subject: bug#54591: 29.0.50; sqlite-select returns blob result as multibyte string Date: Sun, 27 Mar 2022 20:04:41 +0800 Message-ID: <87fsn338km.fsf@yahoo.com> References: <83h77jaof6.fsf@gnu.org> Reply-To: Po Lu Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="17329"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.91 (gnu/linux) Cc: 54591@debbugs.gnu.org, Yuan Fu To: Eli Zaretskii Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Sun Mar 27 14:05:24 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 1nYRe8-0004FA-I3 for geb-bug-gnu-emacs@m.gmane-mx.org; Sun, 27 Mar 2022 14:05:24 +0200 Original-Received: from localhost ([::1]:49322 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nYRe7-0006pg-29 for geb-bug-gnu-emacs@m.gmane-mx.org; Sun, 27 Mar 2022 08:05:23 -0400 Original-Received: from eggs.gnu.org ([209.51.188.92]:36138) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nYRdm-0006oH-Rw for bug-gnu-emacs@gnu.org; Sun, 27 Mar 2022 08:05:02 -0400 Original-Received: from debbugs.gnu.org ([209.51.188.43]:33287) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1nYRdm-0000Go-HP for bug-gnu-emacs@gnu.org; Sun, 27 Mar 2022 08:05:02 -0400 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1nYRdm-0006s2-3o for bug-gnu-emacs@gnu.org; Sun, 27 Mar 2022 08:05:02 -0400 X-Loop: help-debbugs@gnu.org Resent-From: Po Lu Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Sun, 27 Mar 2022 12:05: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.164838269826397 (code B ref 54591); Sun, 27 Mar 2022 12:05:02 +0000 Original-Received: (at 54591) by debbugs.gnu.org; 27 Mar 2022 12:04:58 +0000 Original-Received: from localhost ([127.0.0.1]:55417 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1nYRdh-0006rh-RC for submit@debbugs.gnu.org; Sun, 27 Mar 2022 08:04:58 -0400 Original-Received: from sonic316-20.consmr.mail.ne1.yahoo.com ([66.163.187.146]:33297) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1nYRdf-0006rT-La for 54591@debbugs.gnu.org; Sun, 27 Mar 2022 08:04:56 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1648382690; bh=XvpIX9VhrDlT3fJFeuJs5hqWSMIXqut2mZH7ndto6QE=; h=From:To:Cc:Subject:References:Date:In-Reply-To:From:Subject:Reply-To; b=Q5v7+fpnqXa4tWOr5jsDE34GrmuhS9Efk0JBS72uE1TWb6cRb1rmKfwwW4MmqLygKd+sE4d9F6LZ+ET+N4VwOdT+sAY8REdBkCsIgB4PO4GRYXfEbXMZmohU9oWxCoLWVFmXMaXVENvIJbBhY6Il4Ge0v4CuJpvqOaaCLCgdo9pqzgYdIhN3iU7H7W8aUftY6YwVSnI/74Wc+tk8W+DInrEjymAZMESrfjmYMygG0tavwlkntRt3Hi8EM1zf5YcCasNfZhmh1rtXfGE9OVEt7IQgyy0f6li9d/clsnSRdlM2HLiYhyHdYaRTrbdtnkwz2SahxsgwJnBTi74KBtCO4w== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1648382690; bh=7l2aK3Q/g+MYkSZC1W8cPgpZTxoiA951SxYYHjPvLHn=; h=X-Sonic-MF:From:To:Subject:Date:From:Subject; b=oXYj/pa24Zhrtjp5CBG3h14Lt6LUDj0NOjBopbJ8t4aXcn8JRWZqCPtoVDPccW+2oFextbX70ba/ldpmvv8Z5n4ESdYOStTYWYDjyywajS9BuMi4ooUx31LMEDYU9t+QepANR7HXBxO5oPbVzVWpp6IpzKqdQPUz1Kp9V5AvCpoZ1FOzDyIVmMGIHa9AzgyLNylbWYfcqrZ6ckJXp0gqauZ+gH1U7lMav7rou5kH1fhitwfmSQDMw9DHskRkWUztyuhvoH0VLQzyUfTZ5QkeZD+LSyHTAbTeQ+2xh8pInOsZLNqTAtXBfhuEdXIQxBgYf/nbsfaEKsksE3Zu0y7Qgw== X-YMail-OSG: SucuTlkVM1mlk7k5rps3YjPC9YefAodA8Pl2xGuVPXJ_KXGbVB_mewiOnAjUBcT VPNEo34uEq9YKBWT91DLKlGU0iSCrJTi5UZhip50VSVQbywbK2o7jslvIjMxf67Yi6cGBqPMEfBB qM79TmemriRHL7zgjij6RrNqgtksNZwb3c6gjMQU5Lg8bszyfDV2nqK4r6FJ9ixnjW5XnjaUCPLP aA6YLSOgB5U48ehhZIoeEpTLvh093CmSBEKsLP68Oe3t76dxbaH887c4iXkrr2HdrCnWXTJl.9V2 KR0QvOvpRdeGPCTFdOyxZRGGYn7vLXC4rOGDGTvMjVUUxKdYbPkIudTFko7oUHPbzlrNPkeA8KZM 6QO.VVI6sqkPfPAEgv6HHT_ojDTkTQlceMXisjr.3oAy2r73S7.0o_wab0dTgpYP1HxJEgnIl7ZT SZl0HCap5up7jaGd6TUASYFaZRwBrYhU6OXWaPeDQxuHJWzxRLcyLwiR.QCvsBWVQ757Wv2OQzga z6RIPXVLoSt2pL6k1MWDIL7giFSPCf4GirGwE1PJ6jlUWyXTYfs13ZSao5ojkT5T5pzOO_UN0naD wjwwT4I2VgKxX_kzwXtoCvvzPMn8cfl.cM9QxMqbXAnCW8AfcteUxIkm_Ei2cL.ijjNF.yaeOsfk xmUh5o4pj_yhF2j1ogmI7ujHbPaXIc0tPSbE_rSnWmSBBqNVmyurl8xObCSAQqOFL9Z_lbtx4HNs egtsviG06V8cTdycuCZ26LZVrYbUAvS.RFMkrqJH0p3zn9gslEpVizSUBek.e5PnCC2qqGs0ezKm U4RPtSCyzXy4Q0yF3KBbqk1VTzlCV_4kGqGk23LAOU X-Sonic-MF: Original-Received: from sonic.gate.mail.ne1.yahoo.com by sonic316.consmr.mail.ne1.yahoo.com with HTTP; Sun, 27 Mar 2022 12:04:50 +0000 Original-Received: by kubenode502.mail-prod1.omega.sg3.yahoo.com (VZM Hermes SMTP Server) with ESMTPA ID 8ffee32df7e2c5011c29ba333128777a; Sun, 27 Mar 2022 12:04:47 +0000 (UTC) In-Reply-To: <83h77jaof6.fsf@gnu.org> (Eli Zaretskii's message of "Sun, 27 Mar 2022 09:40:29 +0300") X-Mailer: WebService/1.1.19987 mail.backend.jedi.jws.acl:role.jedi.acl.token.atz.jws.hermes.yahoo 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:228991 Archived-At: Eli Zaretskii writes: > If we want to support non-text data in a blob, then yes, I think you > are right. BTW, I thought things can go awry quickly if misformed sequences find their way into a multibyte string, so any data which isn't decoded or guaranteed to be valid in Emacs's internal superset of Unicode shouldn't be allowed to get into in a multibyte string. Is that correct? Thanks in advance.