Re: LIKE case-insentive ?

Hello Henri

Off the top of  my head I suppose you could get the case-insensitive 
part by casting both sides to Upper or Lower case.

SELECT "WORD" FROM "WORDS" "WORDS" where ucase( "WORD" ) LIKE ucase('Fish')

Don't think that will do the trick with accents...but I will keep thinking.

Drew Jensen

Henri Troismoulins wrote:

>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]
>
>
>
>  
>