SQLite
View Ticket
Not logged in
Ticket UUID: 80369eddd5c94d49f7fbbcf5d442bac618549aa7
Title: Incorrect case folding in the LIKE operator
Status: Fixed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2016-01-20 14:25:16
Version Found In: 3.10.0
User Comments:
drh added on 2016-01-20 14:07:10: (text/x-fossil-wiki)
The following (equivalent) queries return true, when the correct answer is false:

<blockquote><verbatim>
SELECT 'き' LIKE 'ね';
SELECT char(0x304d) LIKE char(0x306d);
</verbatim></blockquote>

The culprit seems to be check-in [0a99a8c4facf] on [2015-12-30 14:06:22].  Case comparison is only looking at the lower 8 bytes of unicode values.