> Hello, > > I issue the following command: > alter character set utf8 set default collation unicode_ci_ai > > Now i need your help to make a case sensitive comparative like this: > > select * from USERS where password='wOrD'; > > Currently, with this collation the where clause ignores the case of > the characters.
>Collation UNICODE_CI_AI is by definition case insensitive, that is what the CI >stands for in the collation name. >You either need to use collation UNICODE, >or one of the other available case sensitive collations, or you need to >create a specific collation. select * from USERS where password collate unicode = 'wOrD'; Though I think using COLLATE like this means that indexes (except expression indexes) cannot be used. HTH, Set