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 sensitivity/insensitivity from OS level to your mysqlDB. Giving lower_case_table_names=2 might work in your scenario. (Ex: I have used lower_case_table_names=1 to make mysql case insensitive for Linux) link[2] describes ow to configure that property. [1]https://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html [2] http://stackoverflow.com/questions/11165944/how-to-change-mysql-table-names-in-linux-server-to-be-case-insensitive Thanks, On Thu, Oct 15, 2015 at 5:59 PM, Mahesh Chinthaka <mahe...@wso2.com> wrote: > 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 <hasit...@wso2.com> > wrote: > >> 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 <mahe...@wso2.com> >> wrote: >> >>> 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, 2015 at 5:43 PM, Hasitha Hiranya <hasit...@wso2.com> >>> wrote: >>> >>>> 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* <http://abeykoon.blogspot.com> >>>> >>>> >>>> _______________________________________________ >>>> Dev mailing list >>>> Dev@wso2.org >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >>> >>> -- >>> *Mahesh Chinthaka Vidanagama* | Software Engineer >>> WSO2, Inc | lean. enterprise. middleware. >>> #20, Palm Grove, Colombo 03, Sri Lanka >>> Mobile: +94 71 63 63 083 | Work: +94 112 145 345 >>> Email: mahe...@wso2.com | Web: www.wso2.com >>> >> >> >> >> -- >> *Hasitha Abeykoon* >> Senior Software Engineer; WSO2, Inc.; http://wso2.com >> *cell:* *+94 719363063* >> *blog: **abeykoon.blogspot.com* <http://abeykoon.blogspot.com> >> >> > > > -- > *Mahesh Chinthaka Vidanagama* | Software Engineer > WSO2, Inc | lean. enterprise. middleware. > #20, Palm Grove, Colombo 03, Sri Lanka > Mobile: +94 71 63 63 083 | Work: +94 112 145 345 > Email: mahe...@wso2.com | Web: www.wso2.com > > _______________________________________________ > Dev mailing list > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Denuwanthi De Silva Software Engineer; WSO2 Inc.; http://wso2.com, Email: denuwan...@wso2.com Blog: https://denuwanthi.wordpress.com/
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
