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 17:40:52 +0200 Message-ID: <87pmlzh4sb.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> <878rsnlh6n.fsf@gnus.org> <83ee2f4la9.fsf@gnu.org> <875ynrk0tg.fsf@gnus.org> <83czhz4ic1.fsf@gnu.org> <87ilrrijy7.fsf@gnus.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="10540"; 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 17:42:10 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 1naftB-0002Vh-V5 for geb-bug-gnu-emacs@m.gmane-mx.org; Sat, 02 Apr 2022 17:42:09 +0200 Original-Received: from localhost ([::1]:53340 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1naftA-000167-LL for geb-bug-gnu-emacs@m.gmane-mx.org; Sat, 02 Apr 2022 11:42:08 -0400 Original-Received: from eggs.gnu.org ([209.51.188.92]:60558) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1naft4-00015z-Nh for bug-gnu-emacs@gnu.org; Sat, 02 Apr 2022 11:42:02 -0400 Original-Received: from debbugs.gnu.org ([209.51.188.43]:52707) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1naft4-0006Ur-Eo for bug-gnu-emacs@gnu.org; Sat, 02 Apr 2022 11:42:02 -0400 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1naft4-0006bL-D8 for bug-gnu-emacs@gnu.org; Sat, 02 Apr 2022 11:42: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 15:42: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.164891406425303 (code B ref 54591); Sat, 02 Apr 2022 15:42:02 +0000 Original-Received: (at 54591) by debbugs.gnu.org; 2 Apr 2022 15:41:04 +0000 Original-Received: from localhost ([127.0.0.1]:46604 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1nafs8-0006a1-4s for submit@debbugs.gnu.org; Sat, 02 Apr 2022 11:41:04 -0400 Original-Received: from quimby.gnus.org ([95.216.78.240]:50700) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1nafs5-0006ZO-MG for 54591@debbugs.gnu.org; Sat, 02 Apr 2022 11:41:02 -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=HLsY7Ez2FMd5SiT0JkBI/T0817k6SBvIw0KdEP6WCNU=; b=QLyUXxX+e+C2xAxCNa9AU6RYTC 4ad3koBBjcMVv4pmRO+iabmXgw1PRy0flCx+/afkxwtimLIOZHBzCoB1TePTiJcZj3YKub+u/HNMz /mOJlUXngNMDlXPoci7OrIKFcuAl1y/LyNNA8KwH6kjJaEe/rlgmlIFANlFr/dJSbcf8=; 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 1nafrw-0007dD-VT; Sat, 02 Apr 2022 17:40:55 +0200 Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwAgMAAAAqbBEUAAAABGdBTUEAALGPC/xhBQAAACBj SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAADFBMVEUVEw1cRSO0i0r/ ///bjJdBAAAAAWJLR0QDEQxM8gAAAAd0SU1FB+YEAg8aDg+JrJUAAAGASURBVCjPRZLPauMwEMY/ F8vQPZUSH5I36D6FDOse9qSARtQ6tZCEtZ+ifYMGoh5ySiAq1Tzljuy49WGGn0bzzR8ZqMji+ys8 hxGX2ZD75IN4r8X8/st8Ed/nSP3I6Sx+kcFW/LW+5kN7jnQ3gipJYEsTKBo4panWbU3MnOIIzjoe +BhzEUiy3DumCfoMQzI/kRkSZQW2V3AZDiNw8Bn2E8Ru+IGPkCHMAsMnczuBvS2in9XMyocjzXWc a7e1vkqbXXhezxBf9MmMQ29j4A865fNfEjlsQ/+cYSWwN693BoXGIPPUvbUEpeFBYdhUj40uNSrY lk83HlppVeDL8blZCZhqJwL88qYWUKZhgbNINaK8GZCimlrBsgcRQSPvfe1QmEW1/5MjRmVb5fmH V12MD5HTuZHG5aU7sqVl2AJcwgeUYKQCodX3FwNtsGux10t3MfQOPBwQap8o5kWtLrC9J5eMLqH+ 4cnKk8g9kp8Ist2u7d5JGizQ1bSpSZdGw/0HY2ekTYBvNMQAAAAldEVYdGRhdGU6Y3JlYXRlADIw MjItMDQtMDJUMTU6MjY6MTQrMDA6MDChszidAAAAJXRFWHRkYXRlOm1vZGlmeQAyMDIyLTA0LTAy VDE1OjI2OjE0KzAwOjAw0O6AIQAAAABJRU5ErkJggg== X-Now-Playing: Prince's _Sign 'O' The Times (1)_: "Starfish and Coffee" In-Reply-To: <87ilrrijy7.fsf@gnus.org> (Lars Ingebrigtsen's message of "Sat, 02 Apr 2022 17:28:00 +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:229286 Archived-At: Lars Ingebrigtsen writes: > No, I posted a later post which has the solution I'm going to implement. (Which is basically a tweak on one of the solutions I proposed in my first message in this thread (with the comment "yuck"). I'm still waiting for somebody to correct me that I'm reading the sqlite documentation wrong and that you can actually find out the column type you're inserting into, because it seems rather absurd that that functionality doesn't exist.) -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no