Extra characters in my column [message #384902] |
Thu, 05 February 2009 12:22 |
kuglerax
Messages: 4 Registered: June 2008 Location: NYC
|
Junior Member |
|
|
Hi all,
Here is a quick summary of the environment
Database:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
NLS_CHARACTERSET=AL32UTF8
NS_NCHAR_CHARACTERSET=AL16UTF16
We are using the Transparent Gateway for DRDA to connect to AS/400 (CCSID 66535)
The issue?
When I extract data out of AS/400
Here is a sample data
MYCOSTATIN®
Its gettting converted to this:
MYCOSTATIN®
Does anyone have a solution to this?
Thank you in advnace
Alex
|
|
|
|