Lev Assinovsky schrieb:

>
> First of all 'containing' is case sensitive.

No, it is case insensitive!
"Like", "starting with" etc are case sensitive, but "containing" is not.

> THe solution (I assume your search word <WORD>
> in column <COL> and your character set is <CHARSET>):
> select ... where UPPER(<COL> collate <CHARSET>) containing UPPER(<WORD>
> collate <CHARSET>)

> > executing a select statement with containing clausel:
> > select * from land where name containing 'öste'
> > returns 0 rows, but there is a row with the name=Österreich
> >
> > All other character working fine, for example:
> > select * from land where name containing 'deu'
> > returns 1 row with name=Deutschland
> >

How do you do the selet?
From an application?
If so, make sure that your connection has the right charcter set
defined.
If you have (for example) character set NONE, you can't pass Umlaute
(äöü...) to your database.

HTH
Luc.