stevebot stevebot - 9 months ago 63
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: