Ansi/Ascii-Charactertranslation ODBC-Oracle

Hello all,

I am using D5 Pro, Oracle-ODBC-Driver 9.00.11. I have problems with "german
umlaute" like "Straße, München, ...". I make the same query with
Oracle-Worksheet without ODBC, with MS-Access/Oracle-ODBC-Driver 9.00.11 and
in both Testcases all umlaute are ok. In D5 Pro with this Oracle-ODBC-Driver
the umlaute are not ok.

any suggestions??

Thanks
George

George,

> I am using D5 Pro, Oracle-ODBC-Driver 9.00.11. I have problems with
"german
> umlaute" like "Straße, München, ...". I make the same query with
> Oracle-Worksheet without ODBC, with MS-Access/Oracle-ODBC-Driver 9.00.11
and
> in both Testcases all umlaute are ok. In D5 Pro with this
Oracle-ODBC-Driver
> the umlaute are not ok.
>
> any suggestions??

Are you using prepared statements?  If not, you might try it.  For example,
a string containing $| causes grief w/o preparing.  My hunch is that this is
a different problem though.

Have a good one,

Bill

--
Wilhelm K. Schwab, Ph.D.
[hidden email]

Hello Hagn,

> I am using D5 Pro, Oracle-ODBC-Driver 9.00.11. I have problems with
> "german umlaute" like "Straße, München, ...". I make the same query
> with Oracle-Worksheet without ODBC, with MS-Access/Oracle-ODBC-Driver
> 9.00.11 and in both Testcases all umlaute are ok. In D5 Pro with this
> Oracle-ODBC-Driver the umlaute are not ok.
>
> any suggestions??

Are you sure NLS_LANG set correctly? We have no localization problems with
D5 - Merant/native Oracle ODBC driver 8.17.

Dmitry Zamotkin

Thanks Bill, Dmitry

Now I have tried some different ODBC-Drivers and it seems, that my problems
exist only with the oracle odbc 9.00.11... With others (for example the
microsoft odbc for oracle 2.573.5303.00) everything works fine. I have also
tried the $| character (select name1||name3 name, strasse, ....). Even this
works fine.

Georg


"Hagn Georg" <[hidden email]> schrieb im Newsbeitrag
news:ans79o$gt7pi$[hidden email]...
> Hello all,
>
> I am using D5 Pro, Oracle-ODBC-Driver 9.00.11. I have problems with
"german
> umlaute" like "Straße, München, ...". I make the same query with
> Oracle-Worksheet without ODBC, with MS-Access/Oracle-ODBC-Driver 9.00.11
and
> in both Testcases all umlaute are ok. In D5 Pro with this
Oracle-ODBC-Driver
> the umlaute are not ok.
>
> any suggestions??
>
> Thanks
> George
>
>