I have a linked server to DB2 database on AS400 machine. The data in the db are encoded using EBCDIC 870 code page and contain characters like Ž (hex B8 in EBCDIC), Ř (hex AE).
The SQL server uses Win1250 code page and I need to receive a correct characters, when querying data from the linked server by OPENQUERY like for example
SELECT * FROM OPENQUERY(AS400, 'SELECT * FROM SSCUSTP')
The problem is that SQL Server has no native support for the EBCDIC 870 code page.
If you use
SELECT * FROM fn_helpcollations()
You can see a few EBCDIC collation, but not 870.
When simply calling the above mentioned select to retrieve data, I receive wrong characters for non ASCII characters. What more, in the result more EBCDIC characters are converted tot he same Win1250 characters.
We are using IBM DB2 ODBC driver for the Linked Server.
Any help for this?