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?