Re: MySQL case sensitive search

From: Aristedes Maniatis (ar..aniatis.org)
Date: Mon Feb 01 2010 - 03:30:27 EST

  • Next message: Andrus Adamchik: "Re: MySQL case sensitive search"

    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:31:40 EST