Case-sensitive queries

Hi,

I noted that case-sensitive queries in text fields in mySQL-based databses do not appear to work as they should, that is, they behave as case-insensitive. It seems to work correctly on Derby-based databases (I tried the Wombat demo databse).

Can you confirm this?

Thanks,

Evert

Hi Evert,

that's right, case-sensitive search is currently not supported on MySQL database. It's also mentioned in the docs: http://www.chemaxon.com/instantjchem/ijc_latest/docs/user/help/htmlfiles/managing_data/queries/query_builder.html#case-insensitive

We will support case-sensitive search on MySQL in some future version.

Filip