Ari, there's more to it. MySQL is "special" as always:
http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html
Andrus
On Feb 1, 2010, at 10:30 AM, Aristedes Maniatis wrote:
> That task is just about optimising the use of indexes for searching
> case insensitive. Just use Cayenne's normal case insensitive flag on
> the query and it will work fine. Just not use any index.
>
> Ari
>
> On 1/02/10 7:14 PM, Nishant Neeraj wrote:
>> Hi,
>> Is there a way to write an expression in Cayenne that performs case
>> sensitive search over a column? Something like this:
>>
>> SELECT ... FROM TEMP_USERS t0 WHERE binary t0.USER_NAME = 'CaMeL';
>>
>> I am using MySQL. Is this something related to this?
>> http://n3.nabble.com/Re-jira-Created-CAY-1210-mysql-does-not-use-index-for-case-insensitive-searches-td14852.html
>> ThanksNishant
>>
>>
>> Your Mail works best with the New Yahoo Optimized IE8. Get it
>> NOW! http://downloads.yahoo.com/in/internetexplorer/
>
> --
> -------------------------->
> Aristedes Maniatis
> GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
>
This archive was generated by hypermail 2.0.0 : Mon Feb 01 2010 - 03:32:34 EST