stevebot stevebot - 1 year ago 125
Java Question

H2 In memory DB treating ORDER BY differently in MySQL mode

I have a query that does an

on a VARCHAR column that contains email addresses.

If I hit my physical MySQL db, it ignores case in the
. However, my h2 in-memory DB is respecting case. It is set to MySQL mode.

Anyone know why this is?

Answer Source

Case sensitivity when evaluating strings in databases is determined by the collation.

Check the collation handling on H2:

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download