Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Querying Arabic data returns junk characters

User353235Mar 11 2013 — edited May 12 2013
Hi,

I am getting junk characters while querying MS SQL 2008 table from gateway connection (db lilnks). Below are the initialization parameters i am using for DG4ODBC.
##########################
HS_FDS_CONNECT_INFO = mssql
HS_FDS_TRACE_LEVEL = off
HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so
HS_FDS_SUPPORT_STATISTICS=FALSE
HS_LANGUAGE = AMERICAN_AMERICA.AR8MSWIN1256
HS_NLS_NCHAR=UCS2
##########################

I tried this with SQLPLUS and Putty, both gives different junk characters.

Database version: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

DG4ODBC version:
Heterogeneous Agent Release 11.1.0.7.0 - 64bit Production Built with
Oracle Database Gateway for ODBC

OS : RHELinux 5 - 64 bit

Than You,
Mohammed.

Edited by: 906610 on Mar 11, 2013 7:17 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2013
Added on Mar 11 2013
5 comments
4,196 views