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/