why not using utf8_unicode_ci (ci stands for case ins.)?
using this for all tables will take care of your poblem at the root
(without having to change fields)
Am Sonntag, 8. Juli 2012 11:48:21 UTC+2 schrieb JonStark:
>
> Oh thanks never knew about this ! Do you know how to edit a table field
> with phpMYAdmin to allow case sensitivity ?
>
> Thanks !
>
> Le dimanche 8 juillet 2012 02:16:09 UTC+2, JonStark a écrit :
>>
>> Hi !
>>
>> I have an app where user profiles can be found thanks to their username
>> or hash as parameter :
>>
>> public function view($username) {
>>> $user = $this->User->find('first', array(
>>> 'conditions' => array(
>>> "or" => array(
>>> 'User.hash' => $username,
>>> 'User.username' => $username
>>> )
>>> ),
>>> ));
>>>
>>
>>> $this->set(compact('user'));
>>
>>
>>> }
>>
>>
>> This allows me to find an user with both :
>>
>> app.com/users/view/username or
>> app.com/users/view/xdedweZDE654
>>
>> The problem is that I found that if a user is for example USERNAME, if a
>> second user is named UserName, the url app.com/users/view/UserName it
>> will still display USERNAME profile... Is there a way to force cake to take
>> into account parameter cases ?
>>
>> Thanks a lot !
>>
>
--
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
