]> Sergey Matveev's repositories - public-inbox.git/commit
lei_mail_sync: ensure URLs and folder names are stored as binary
authorEric Wong <e@80x24.org>
Sat, 2 Apr 2022 01:13:51 +0000 (01:13 +0000)
committerEric Wong <e@80x24.org>
Sat, 2 Apr 2022 04:39:24 +0000 (04:39 +0000)
commit42e1fb419b74e0b5c9315dacdd08a0e0c91962e5
treea1f4ca1c77a4d8d7c2d639d569139db288a14e05
parent388ccd960deadfda46deba813c7f6fea01bfeef1
lei_mail_sync: ensure URLs and folder names are stored as binary

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.
lib/PublicInbox/LeiMailSync.pm
t/lei_mail_sync.t