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

[camel]

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.

[scoy]

> SQL VARCHAR fields are usually not case sensitive

I beg to differ - what makes you say this?

In any event - you can override this in your application's own 'jbosscmp-jdbc.xml' deployment descriptor.

Steve Coy

[camel]

> I beg to differ - what makes you say this?


I could be wrong -- I have only used MySQL, which treats VARCHAR columns as case-insensitive when searching. Are other databases (Oracle, MS SQL, Postgres) different? thanks