Hi, i got 2 servers one with Windows Server 2008 R2 and DB2 ODBC client version v7.1.0 , and other one with Windows Server 2019 and DB2 ODBC client v10.5.11, on both servers we have a visual studio project that uses SSIS to query from our "DB2 for z/OS v11" server.
The data that stored in database is actually in Persian language and uses 1256 encoding but stored as ASCII in the database.
we use this sample query in our SSIS project to retrieve data from database:
SELECT CAST(clientAddress as VARCHAR(100) CCSID 1252) as clientAddress from testTable with UR;
Everything is fine in Windows Server 2008 R2 and data in Preview Query Results in ADO.NET Source Editor in SSIS shows results in Persian language, but in Windows Server 2019 it tries to show the output as 1252 encoding.
Any idea how can i enforce DB2 ODBC client to show data with 1256 encoding?
On both servers locale is set to Persian, and DB2CODEPAGE equals to 1252, also we use a System DSN with IBM DB2 ODBC driver to connect to the remote database.#
------------------------------
yooness rostamy
------------------------------