Skip to Content
0

ABAP use native SQL read msssql server return garbled code

Dec 05, 2017 at 09:52 AM

32

avatar image
Former Member

This is a none unicode SAP system, I have use DBCO connect to a external database(MSSQL SERVER for chinese), when I use native SQL read external table, chinese content will be garbled. I konw the garbled solution for oracle database(add :

ZHS16GBK' on the conn.info ). Is there a same parameter for MSSQL SERVER conn.info?

SAP系统是在英文环境下的none unicode系统,连接中文的MS SQLSERVER,通过ABAP native SQL读取数据库中的中文内容显示是乱码,有谁有解吗?
该系统连接中文环境的ORACLE数据库也出现过乱码,在DBCO的连接信息里面添加“:ZHS16GBK”可以解决这个问题,在连接MSSQL的连接信息中是否也有类似的参数可以指定呢?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Dec 11, 2017 at 07:23 AM
0

I have a new find, this non-unicode system read the char() type field is OK, The garbled happen to read nchar() type.

Share
10 |10000 characters needed characters left characters exceeded