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

camel Aug 16, 2003 7:38 PM

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.

1. Re: MySQL String mapping is "VARCHAR(250) BINARY", causing p

scoy Aug 18, 2003 6:39 AM (in response to camel)

> 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
Actions
2. Re: MySQL String mapping is "VARCHAR(250) BINARY", causing p

camel Aug 18, 2003 3:03 PM (in response to 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
Actions

Go to original post