Subject Re: How to make a case sensitive comparative with collation unicode_ci_ai
Author peixinhosdalua
It does not work. I also changed the table to:

CREATE TABLE UTILIZADORES
(
ID INTEGER NOT NULL,
UTILIZADOR VARCHAR(25) NOT NULL COLLATE UNICODE_CI_AI,
CHAVE VARCHAR(25) NOT NULL COLLATE UNICODE,
NOME VARCHAR(100) NOT NULL COLLATE UNICODE_CI_AI,
CONSTRAINT C_UTILIZADORES1 PRIMARY KEY (ID)
);

and making:
select ID,NOME from UTILIZADORES where CHAVE ='word'

still returns the record with CHAVE='w0rD'.

server version wi-2.5.0.26074
Any more suggestions?