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 <[email protected]> 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 <[email protected]> > 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 <[email protected]> >> 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 >>> [email protected] >>> 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: [email protected] | 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: [email protected] | Web: www.wso2.com
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
