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
