First of all 'containing' is case sensitive.
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>)


zipzipziping wrote:

> hi all,
>
> ich have a problem with the german characters �,� and �.
>
> 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
>
> Because i think, that containing is not casesensitiv
> the first statement should return a row, too like the
> second statement.
>
> Is there a workaround or is this a bug or is there something
> that i do wrong (charset or something)???
>
> Please help me !!!
> fb
>
>
> 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@...




[Non-text portions of this message have been removed]