Lucas Franzen wrote:

> Lev Assinovsky schrieb:
> >
> > First of all 'containing' is case sensitive.
>

Thanks. I didn't know.
Then the problem I believe is that
searched column doesn't have correct character set.

>
> 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.
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

--
Lev Assinovsky Peterlink Web
Programmer St. Petersburg, Russia
Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7а
E-mail: lev@...