LIKE case-insentive ?

Hello,

I am usign OO 1.9.121 with MySQL 4.1.10a and MyODBC 3.51.10 (SuSE 9.3)
I would like to use HSQLDB.

When querying text fields with MySQL, LIKE is case-insentitive (and 
accent-insensitive).

But LIKE in HSQLDB is case and accent sensitive. I read in the documentation 
that : "LIKE, by definition, is case-sensitive (though some databases don't 
see it that strict)."

Is it possible to write a LIKE query, case-insensitive and accent-insentive ?

For example :
LIKE '*pere*' 
would return me texts with : Père; père; Pere; pere etc.

I know this is an SQL question, but I would really appreciate any information 
on this issue.

Thanks in advance.
Regards.

Henri.