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. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
