Subject | german characters ö, ä and ü in containing search conditions |
---|---|
Author | zipzipziping |
Post date | 2002-02-11T16:14:40Z |
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
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