Skip to content

COLLATE NOCASE #1172

@mtissington

Description

@mtissington

This is a UTF16 database

I have a very strange problem when using COLLATE NOCASE on a column.
It seems that when I do a SELECT the WHERE clause is only looking at the first letter.

CREATE TABLE words (
word TEXT COLLATE NOCASE NOT NULL CHECK(word <> ''),
);

INSERT INTO words (word) VALUE ('aw');

SELECT * FROM WORDS WHERE word = 'a'

returns ALL rows that being with 'a'

I might add that using sqlite3.exe produces the correct result.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions