> 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.
> 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