thanks On Sep 15, 1:22 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > I don't know of any CakePHP specific way to force this on MySQL. > You can set your database, table or field to use a case sensitive > collation or you could add a collate parameter to your query. > Each collation has a cs and an ci version like "utf8_general_cs". Also > any binary collation (utf8_bin) will be case sensitive, of course. > > http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html > > /Martin > > On Sep 15, 1:30 am, "[EMAIL PROTECTED]" > > <[EMAIL PROTECTED]> wrote: > > HI, > > > I am using MySQL + CakePHP to develop my application. While using > > method Find to search a user with name "Apple", CakePHP returns a user > > with name "apple". > > > I know MySQL is case insensitive for string by default. How could I > > force Cake to compare them in case sensitive? > > > Thanks, > > Bo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
