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.devel Subject: Re: sqlite3 Date: Sun, 12 Dec 2021 10:12:47 +0100 Message-ID: <87o85mchkg.fsf@gnus.org> References: <87tufmjyai.fsf@gnus.org> <87sfv5ljxn.fsf@gnus.org> <8735n5leza.fsf@gnus.org> <837dch1qox.fsf@gnu.org> <87ee6odu65.fsf@gnus.org> <83h7bjye0b.fsf@gnu.org> <87sfv360np.fsf@gnus.org> <83lf0vw6sg.fsf@gnu.org> <87k0gd1cl3.fsf@gnus.org> <83zgp8svkw.fsf@gnu.org> <83ilvvqwu8.fsf@gnu.org> <87bl1mihb7.fsf@gnus.org> <83k0gapacz.fsf@gnu.org> <874k7ee01l.fsf@gnus.org> <838rwqp4x7.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="34257"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Cc: emacs-devel@gnu.org To: Eli Zaretskii Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Sun Dec 12 10:13:46 2021 Return-path: Envelope-to: ged-emacs-devel@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 1mwKvS-0008gf-CY for ged-emacs-devel@m.gmane-mx.org; Sun, 12 Dec 2021 10:13:46 +0100 Original-Received: from localhost ([::1]:37200 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mwKvQ-0008BA-G0 for ged-emacs-devel@m.gmane-mx.org; Sun, 12 Dec 2021 04:13:44 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:52812) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mwKue-0007VN-5D for emacs-devel@gnu.org; Sun, 12 Dec 2021 04:12:56 -0500 Original-Received: from [2a01:4f9:2b:f0f::2] (port=36292 helo=quimby.gnus.org) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mwKuc-0006az-Il; Sun, 12 Dec 2021 04:12:55 -0500 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=Ex3aMNbBCQ0nhInlGMFxFsXraWT7B1RhAZadAzQvr3E=; b=RbA26ZuP95adczantis/U+QShE 7t8bboT4bVj3xzJz8ZD+fiSgH0Kg7jRC9xCNDCEdfV9PkCE0R8HkatZpLE9qxdJz6tAeUUGoWpz1M st5WEXD+bUCsIO5vc5rGExWh4gbV1EZcV5aj7tLGqVUZf9AmDqFq8MkehnFa7I2va514=; 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 1mwKuX-0003kz-CM; Sun, 12 Dec 2021 10:12:52 +0100 Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAABGdBTUEAALGPC/xhBQAAACBj SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAAG1BMVEWwdmqWYVlhLitD MDKROS+nRjXAgXHCbFn///97ekHOAAAAAWJLR0QIht6VegAAAAd0SU1FB+UMDAkIIY4a0/EAAAGy SURBVDjLrZNNTgMxDIUzCA3bZuAC46QHIOEChMwBqBKx7Wr2ICSuz7Od+aNboqpS/eU5L8+pMf+8 rN396HZlXqeb7Z21w2gPImwWAcUYR7trJds6qcdgjz3wPURZz3YVcAkyInJHiXUMnogXwLj4kh6m SwLcBjrWRxUkllDr9SZHmoEo55w2cK9eDAnI6NXA4xEkcgq6uACfa2UJKbhbAeq1sjWE0q+dGEwA JTnStNwGVOI0xuWIaLIoaiH3F3C58uEjz+prBZOC1MDwBxQAme7jLUgMHhBUcDuAi+QF6BQWkGni Oe+AuoLdBoJOJxrfbOXKZwO0rI0XScnpvQH8muAeNy+4O8ArX7wBmIGirQ0UAUsdbs3MriCHiBqg Bbh4ZlAU8Hhf7anfQFqBh6CfZ4AXTchoXcYHgMcWFlBXMCuYOCDirJK0wv75+gmgzc36RiC49gz8 lLNrwBPeYT9f5wHx+ZySgpLOheIIu99EASBvoArpPJq6Fxm0aZnXiwvjwFtd8DjbrQAOop8S5odP FvCB0Dl5cr4mnmwgnyLAT5MUdL/IyL2/NNBeSlAF/hmX+AuOVbuTqAOyYwAAACV0RVh0ZGF0ZTpj cmVhdGUAMjAyMS0xMi0xMlQwOTowODozMyswMDowMCFEhscAAAAldEVYdGRhdGU6bW9kaWZ5ADIw MjEtMTItMTJUMDk6MDg6MzMrMDA6MDBQGT57AAAAAElFTkSuQmCC X-Now-Playing: Insides's _Soft Bonds_: "Subordinate" In-Reply-To: <838rwqp4x7.fsf@gnu.org> (Eli Zaretskii's message of "Sun, 12 Dec 2021 11:07:32 +0200") X-Host-Lookup-Failed: Reverse DNS lookup failed for 2a01:4f9:2b:f0f::2 (failed) Received-SPF: pass client-ip=2a01:4f9:2b:f0f::2; envelope-from=larsi@gnus.org; helo=quimby.gnus.org X-Spam_score_int: -35 X-Spam_score: -3.6 X-Spam_bar: --- X-Spam_report: (-3.6 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_MED=-2.3, RDNS_NONE=0.793, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-devel@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "Emacs development discussions." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Original-Sender: "Emacs-devel" Xref: news.gmane.io gmane.emacs.devel:281778 Archived-At: Eli Zaretskii writes: > No, the usual way is to use ENCODE_FILE, but sqlite3 explicitly wants > file names encoded in UTF-8 regardless of the locale's encoding, > AFAIU. Oh, wow. That's weird. Is that common? I can't recall seeing anything like that with other libraries, but perhaps I'm just misremembering. > So the question is: do we tolerate eight-bit raw bytes in file names > passed to sqlite3? If this is really the case (and the documentation isn't just glossing over details), then I guess we don't tolerate that? -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no