Unable to read text fields with Oracle ODBC

[JeroenDmt]

When I get data from an Oracle table using the ODBC Enterprise stage, all the text fields come out as unprintable characters. For example the text "AMSTERDAM" in the database comes out as

Code: Select all

"䅍協䕒䑁䴀    "

The texts are all normal texts without any special values.

I can read the same table no problem with the Oracle enterprise stage.

What makes it stranger.. when I read the same table with the server ODBC stage, the texts come out normal.

Does anybody know what could be causing this problem?

[ray.wurlod]

Do you have NLS enabled?
Do you have LANG_C or NLS_LANG environment variables set?

[JeroenDmt]

Yes, NLS is enabled and NLS_LANG is set.