Re: [Dev] How to make mySQL DB case sensitive

Hi Hasitha, AFAIK you can set collation at both the database creation and table creation level. And you can set individual tables treated as case sensitive if you want. Please refer[1] [1] - http://stackoverflow.com/questions/4879846/how-to-configure-mysql-to-be-case-sensitive On Thu, Oct 15,

[Dev] How to make mySQL DB case sensitive

Hi Devs, How can we do the subject? Are we doing this in registry/user store DBs? Thanks -- *Hasitha Abeykoon* Senior Software Engineer; WSO2, Inc.; http://wso2.com *cell:* *+94 719363063* *blog: **abeykoon.blogspot.com*

Re: [Dev] How to make mySQL DB case sensitive

Hi Mahesh, Already tried it. Gives me following error [image: Inline image 1] I am using mysql Ver 14.14 Distrib 5.6.23, for osx10.8 (x86_64) Thanks On Thu, Oct 15, 2015 at 5:48 PM, Mahesh Chinthaka wrote: > Hi Hasitha, > > AFAIK you can set collation at both the

Re: [Dev] How to make mySQL DB case sensitive

Hi Hasitha, For MySql DB the case sensitivity of the underlying OS also impacts[1]. For example in Linux mysql db are case sensitive, in OSX and windows not case sensitive. You might be able to configure 'lower_case_table_names' property as mentioned in [1] and apply case

Re: [Dev] How to make mySQL DB case sensitive

Hi Hasitha, Did you try with collation 'utf8_bin' ? CREATE DATABASE test_database CHARACTER SET utf8 COLLATE utf8_bin; On Thu, Oct 15, 2015 at 5:53 PM, Hasitha Hiranya wrote: > Hi Mahesh, > > Already tried it. > Gives me following error > > > [image: Inline image 1] > > I