Re: Case sensitivity in LIKE searches

you should be using utf8_unicode_ci (ci stands for case ins.)
then it should be no problem and the search is always ci!

On 13 Mrz., 14:16, heohni <heidi.anselstet...@consultingteam.de>
wrote:
> Hi,
>
> SELECT ...... FROM `members` AS `Member` WHERE `Member`.`email` LIKE
> '%Hans%'
>
> When I search for "Hans", I find a entry, if I search for "hans" I
> dont find a result.
> Is this because of the UTF-8?
>
> Is there any trick to search and find the results in both cases?

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php