Read about COLLATE parameter and decide what collation you want to use
(latin1_general_cs, ut8_bin etc). Then simply issue an ALTER TABLE X MODIFY
... statement in the SQL window of the phpMyAdmin. But watch out for the
sorting order in your selects, the results of _bin collation may be not
quite what you expect.
On Sunday, July 8, 2012 11:48:21 AM UTC+2, JonStark wrote:
>
> 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
