Skip to Content
avatar image
Former Member

ABAP use native SQL read msssql server return garbled code

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的连接信息中是否也有类似的参数可以指定呢?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

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

    Add comment
    10|10000 characters needed characters exceeded