MySQL case sensitive search

From: Nishant Neeraj (nneeraj12..ahoo.com)
Date: Mon Feb 01 2010 - 03:14:21 EST

  • Next message: Lachlan Deck: "Re: MySQL case sensitive search"

    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/

    This archive was generated by hypermail 2.0.0 : Mon Feb 01 2010 - 03:15:51 EST