Home » RDBMS Server » Networking and Gateways » Extra characters in my column (Oracle Database 10g Enterprise Edition Release 10.2.0.1.0)
Extra characters in my column [message #384902] Thu, 05 February 2009 12:22 Go to next message
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
Re: Extra characters in my column [message #387466 is a reply to message #384902] Thu, 19 February 2009 05:50 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


What's your source & Destination database character set??

CSSCAN

Babu
Previous Topic: ORA-03106: fatal two-task communication protocol error
Next Topic: sqlnet.recv_timeout parameter
Goto Forum:
  


Current Time: Thu Mar 28 19:02:41 CDT 2024