| Subject | Re: How to make a case sensitive comparative with collation unicode_ci_ai | 
|---|---|
| Author | peixinhosdalua | 
| Post date | 2012-07-13T09:47:17Z | 
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?
            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?