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.devel Subject: Re: sqlite3 Date: Sun, 12 Dec 2021 11:07:32 +0200 Message-ID: <838rwqp4x7.fsf@gnu.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> Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="12424"; mail-complaints-to="usenet@ciao.gmane.io" Cc: emacs-devel@gnu.org To: Lars Ingebrigtsen Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Sun Dec 12 10:08:37 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 1mwKqS-00034C-Dl for ged-emacs-devel@m.gmane-mx.org; Sun, 12 Dec 2021 10:08:36 +0100 Original-Received: from localhost ([::1]:33176 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mwKqR-0005JF-C7 for ged-emacs-devel@m.gmane-mx.org; Sun, 12 Dec 2021 04:08:35 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:52160) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mwKpb-0004dG-FQ for emacs-devel@gnu.org; Sun, 12 Dec 2021 04:07:43 -0500 Original-Received: from [2001:470:142:3::e] (port=54542 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 1mwKpb-0004sE-4j; Sun, 12 Dec 2021 04:07:43 -0500 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=t2Dp77ZD0MYSmaITLzxxVQhc/jF2v1QYQD2VaNTrzR4=; b=hVZOIvbQgB/7 ZJQkl3sPv0kaYEr91Vbfu4td7Y9hgzEbAdwKKaMlYDux+f8AG5wqZ+1DuITubUFgwMDyBq3at2CqQ HKGLzZAOCCTxj0SF8YCy6C5YD8hnD6yj6A0c5Blg8BAq8Z0rXIL+zGGbxYGt9bwbz8g7hUL2pKJjn Y5I3OEDKHsMHHBZCiVthCwJIinQlBswCuA7Sj6/epypdrguFbw8L/bg4R9Zun0YHmIJxUfdmBys0J wedvaP57bO9gKuM3l7HAxl2QDKD27bffKPBj94QrbTtJgkMec+8vqxo711b7C8J4S7KIUoH2l0Qzf ErRw0a3ul4I6bAvXVdLhjQ==; Original-Received: from [87.69.77.57] (port=3223 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 1mwKpX-0005Kh-OR; Sun, 12 Dec 2021 04:07:42 -0500 In-Reply-To: <874k7ee01l.fsf@gnus.org> (message from Lars Ingebrigtsen on Sun, 12 Dec 2021 08:48:22 +0100) 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:281776 Archived-At: > From: Lars Ingebrigtsen > Cc: emacs-devel@gnu.org > Date: Sun, 12 Dec 2021 08:48:22 +0100 > > > A related issue is with encoding file names, which are also expected > > to be in UTF-8. I don't know what will happen if a file name includes > > eight-bit raw bytes, for example. At least in the Windows code in > > sqlite3, which I did read, the result will probably be a failure to > > access the file. > > Yeah, file names are a separate issue, and we should encode them in the > usual ways we do. 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. So the question is: do we tolerate eight-bit raw bytes in file names passed to sqlite3?