Re: [dba-users] LIKE case-insentive ?

[Andrew Jensen]

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]



 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]