[firebird-support] Re: How to make a case sensitive comparative with collation unicode_ci_ai

[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?