German Umlaut in WHERE and INSERT Statement
Posted on 2003-12-01
Got a strange Problem with Oracle 8.1.7
I have a DB-Server and 8.1.7 Client both set to character set US7ACII. The Data in the DB can have german 'umlaut' (ä,ö,ü) in the data, usually VARCHAR2 fields.
It's no Problem just to read data from the DB, means the 'umlaut' s will be displayed correctly if they're allready in the DB. (Conversion was made with native connection, there was no problem with the 'umlaut' s)
If I try to search records with an argument with 'umlaut' there will be no result. If I replace the 'umlaut' with an ?, I get the correct Result (with 'umlaut' s in the result, exaclty where I expect it to be)
If I try to write new recordsets, the 'umlauts' are replaced by their origin character (ö --> o, ä --> a, ü --> u).
If I take the Microsoft ODBC for Oracle, it works fine but instead has problemes with too long queries.
- Is there an option to set that the 'umlauts' are accepted also in WHERE and in INSERT? (st. diffrent from installing the db newly, that's no option...)
- Is there a solution with the microsoft ODBC that has no problems with long queries?
thanx for quick answer, many points are waiting for a fast anser! (I will increase points if you provide a fast solution, which I can use to really solve my real world problem!)