Page 1 of 1

Unable to read text fields with Oracle ODBC

Posted: Fri Jul 20, 2007 2:08 am
by 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?

Posted: Fri Jul 20, 2007 10:45 pm
by ray.wurlod
Do you have NLS enabled?
Do you have LANG_C or NLS_LANG environment variables set?

Posted: Sat Jul 21, 2007 3:25 am
by JeroenDmt
Yes, NLS is enabled and NLS_LANG is set.