When we use an advanced query the german ringel s (ß) is not recognized.
When we run the equivallent sql-query directly on the database the ß is recognized so we think the problem is indeed in the advanced query. How can we solve this problem?
Indeed you're right. We're running through Toad, I'll check whith Infra which code page is used, thanks.
That seems like a code page problem. You never really run anything "directly on the database", you always go through tools like Management Studio or Toad. I would advise you to try to see what query is actually run on the database, and check with your DBAs what code page the database uses, etc.