From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <e@80x24.org>
X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on dcvr.yhbt.net
X-Spam-Level: 
X-Spam-ASN:  
X-Spam-Status: No, score=-4.0 required=3.0 tests=ALL_TRUSTED,AWL,BAYES_00,
	T_SCC_BODY_TEXT_LINE shortcircuit=no autolearn=ham autolearn_force=no
	version=3.4.2
Received: from localhost (dcvr.yhbt.net [127.0.0.1])
	by dcvr.yhbt.net (Postfix) with ESMTP id D65911F4CE;
	Sat,  2 Apr 2022 23:45:52 +0000 (UTC)
Date: Sat, 2 Apr 2022 23:45:52 +0000
From: Eric Wong <e@80x24.org>
To: meta@public-inbox.org
Subject: Re: [PATCH 1/2] lei_mail_sync: ensure URLs and folder names are
 stored as binary
Message-ID: <20220402234552.M727371@dcvr>
References: <20220402011352.30964-1-e@80x24.org>
 <20220402011352.30964-2-e@80x24.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <20220402011352.30964-2-e@80x24.org>
List-Id: <meta.public-inbox.org>

Eric Wong <e@80x24.org> wrote:
> Apparently leaving {sqlite_unicode} unset isn't enough, and
> there's subtle differences where BLOBs are stored differently
> than TEXT when dealing with binary data.  We also want to avoid
> odd cases where SQLite will attempt to treat a number-like value
> as an integer.
> 
> This should avoid problems in case non-UTF-8 URLs and pathnames are
> used.  They'll automatically be upgraded if not, but downgrades
> to older lei would cause duplicates to appear.

Ugh, no, not yet.  "lei q" and "lei up" seem to work fine, but
"lei import" is screwed up :x