-
-
Notifications
You must be signed in to change notification settings - Fork 2.3k
Closed
Description
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
Labels
No labels