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
