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 17:56:05 +0300 Message-ID: <83czi7a1h6.fsf@gnu.org> References: <83h77jaof6.fsf@gnu.org> <87fsn338km.fsf@yahoo.com> Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="6946"; mail-complaints-to="usenet@ciao.gmane.io" Cc: 54591@debbugs.gnu.org, casouri@gmail.com To: Po Lu Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Sun Mar 27 16:57:12 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 1nYUKN-0001f6-LY for geb-bug-gnu-emacs@m.gmane-mx.org; Sun, 27 Mar 2022 16:57:11 +0200 Original-Received: from localhost ([::1]:58034 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nYUKM-0003b9-C1 for geb-bug-gnu-emacs@m.gmane-mx.org; Sun, 27 Mar 2022 10:57:10 -0400 Original-Received: from eggs.gnu.org ([209.51.188.92]:56924) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nYUKE-0003am-UI for bug-gnu-emacs@gnu.org; Sun, 27 Mar 2022 10:57:02 -0400 Original-Received: from debbugs.gnu.org ([209.51.188.43]:34285) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1nYUKE-0000x4-Lq for bug-gnu-emacs@gnu.org; Sun, 27 Mar 2022 10:57:02 -0400 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1nYUKE-0002pI-IL for bug-gnu-emacs@gnu.org; Sun, 27 Mar 2022 10:57: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: Sun, 27 Mar 2022 14:57: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.164839297410804 (code B ref 54591); Sun, 27 Mar 2022 14:57:02 +0000 Original-Received: (at 54591) by debbugs.gnu.org; 27 Mar 2022 14:56:14 +0000 Original-Received: from localhost ([127.0.0.1]:56415 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1nYUJS-0002oC-AD for submit@debbugs.gnu.org; Sun, 27 Mar 2022 10:56:14 -0400 Original-Received: from eggs.gnu.org ([209.51.188.92]:40880) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1nYUJQ-0002nx-3A for 54591@debbugs.gnu.org; Sun, 27 Mar 2022 10:56:12 -0400 Original-Received: from [2001:470:142:3::e] (port=45038 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 1nYUJK-0000ue-P2; Sun, 27 Mar 2022 10:56:06 -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=Dt5KvJ/QB+q3tcq+DYJvEwWUHieXUOJqiUjkmyOl9sc=; b=johiYonc+WlE GK7z7Hs3kITGr8nFZX3qNgpZo+TtTy4wnE51G7gw+giHJF0L/cilRikCtDAXWTyrOWz9CNcnsrVY6 KSVF1WL/ZYLWevbr/LL2QLWlSeqSDGE8QvpI9LeUpsTFxgPeUqRQ8KMrrvPIwi5onCveNAA+/Aohg MNimSTIAL4uYDVWpMN/StPfhgHo+XSDmawjI/ouDFtTjBcUVgemqrYSgTD8fT0XDP5a/JlW4vXO2p 2tkKz+tOkyl4KZT0h5QiuZT9iiYwmU95ptNvIPj5np48Zil2U9yLSoc5c0GV1TpekcoBdkT50naNI MsFfdFjYQ41y8lYzE3m1fw==; Original-Received: from [87.69.77.57] (port=4890 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 1nYUJK-0000IH-1g; Sun, 27 Mar 2022 10:56:06 -0400 In-Reply-To: <87fsn338km.fsf@yahoo.com> (message from Po Lu on Sun, 27 Mar 2022 20:04:41 +0800) 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:228992 Archived-At: > From: Po Lu > Cc: Yuan Fu , 54591@debbugs.gnu.org > Date: Sun, 27 Mar 2022 20:04:41 +0800 > > 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? No. Emacs converts any invalid byte sequences to raw bytes, which have a special internal representation that cannot harm us.