From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: 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 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: Eric Wong 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