Skip to content

LIKE shouldn't fold non-ASCII characters by default #3318

@LeMikaelF

Description

@LeMikaelF

From the documentation:

The LIKE operator is case sensitive by default for unicode characters that are beyond the ASCII range.

For example:

sqlite> SELECT 'A' LIKE 'a', 'Ä' LIKE 'ä';
┌──────────────┬──────────────┐
│ 'A' LIKE 'a' │ 'Ä' LIKE 'ä' │
├──────────────┼──────────────┤
│ 1            │ 0            │
└──────────────┴──────────────┘

But Turso seems to also fold non-ASCII characters:

turso> SELECT 'A' LIKE 'a', 'Ä' LIKE 'ä';
┌──────────────┬──────────────┐
│ 'A' LIKE 'a' │ 'Ä' LIKE 'ä' │
├──────────────┼──────────────┤
│            1 │            1 │
└──────────────┴──────────────┘

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions