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 <[email protected]> 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
