Do yo know if the VARCHAR_IGNORECASE type belongs to the SQL standard?
And have you test it on MySQL (mysql/initDB.sql)?

Hello Arey,
Probably you are so busy I understand but the ticket is still waiting. Could you please check it? @arey

This ticket is still waiting because if your change is working on any RDBMS?

Hello @arey ,
I wrote a comment but probably you haven't seen it. It is on the top.
It was "It is not an SQL standard. It works well with HSQLDB. However, mysql VARCHAR already allows case insensitive search. I mean, developers who use mysql for petclinic db, they already do the case insensitive searches. It is for just HSQLDB. So, we do not need to make any change on mysql/initDB.sql. I tested case insensitive search with both HSQLDB and MYSQL. Everything looks fine."

I'm sorry @broccolinisoup but I didn't see your first comment. In this condition, we can accept your change. Thanks you

No worries @arey Thank you for your time!