Arabic characters appears reversed - access DB2 AS400 using ORACLE gateway ODBC

236 Views Asked by At

I'm trying to access DB2 on AS400 from oracle database using oracle gateway for ODBC.

I'm using the IBM i Access for windows as ODBC driver.

my initdg4odbc.ini gateway configuration is:

HS_FDS_CONNECT_INFO = DSN_name
HS_LANGUAGE=ARABIC_AMERICA.AR8MSWIN1256

Database character set is : ARABIC_AMERICA.AR8MSWIN1256

when I query column with Arabic characters it returns in reversed order:

[a][https://i.stack.imgur.com/yia6P.png

any suggestions please?

thanks

0

There are 0 best solutions below