H2 In a memory database processing ORDER BY differently in MySQL mode

Question

I have a query that executes ORDER BYin a VARCHAR column that contains email addresses.

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

Does anyone know why this is?

Answer 1

Case sensitivity when evaluating rows in databases is determined by matching.

Check H2 sorting processing: http://www.h2database.com/html/grammar.html#set_collation

Answer 2

, SET IGNORECASE TRUE. , .

, MySQL H2 , - : H2 , ( ). , ( ).

Answer 3

Use VARCHAR_IGNORECASEinstead VARCHAR.

Link