2 Replies Latest reply on Aug 18, 2003 3:03 PM by Chris Lamprecht

    MySQL String mapping is "VARCHAR(250) BINARY", causing probl

    Chris Lamprecht Newbie

      I noticed that when doing a search on a String CMP field, it was being case-sensitive (SQL VARCHAR fields are usually not case sensitive). Then I looked in standardjbosscmp-jdbc.xml and found the following mapping for MySQL:


      <java-type>java.lang.String</java-type>
      <jdbc-type>VARCHAR</jdbc-type>
      <sql-type>VARCHAR(250) BINARY</sql-type>


      Shouldn't this just be "VARCHAR(250)", without the "BINARY" ? I looked at the other database mappings for java.lang.String and they don't have the "BINARY" specified.

      Thanks.