Skip to main content

Domino to SAP translation produces garbage text


Technote (FAQ)


Question

You use an LSXLC agent for a connection from a Lotus® Domino® server to SAP using the SAP Connector, version 1.7.2. The data is in rich text format leaving Domino and enters SAP without any problems. When SAP returns the result of the query from Domino, however, the text is garbled and unreadable.

Example of garbled text:
IN_DOCUMENT_ITEMS_TABMATERIAL = ‘“”˜•€€€€€€€€
IN_DOCUMENT_ITEMS_TABEXT_ITM_NO = 
IN_DOCUMENT_ITEMS_TABCUST_MATRL = €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€
IN_DOCUMENT_ITEMS_TABPO_NUMBER = €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€
IN_DOCUMENT_ITEMS_TABPLANT = €€€€
IN_DOCUMENT_ITEMS_TABORDER_QTY = 5000
IN_DOCUMENT_ITEMS_TABSALES_UOM = €€€
IN_DOCUMENT_ITEMS_TABCOND_TYPE = €€€€
IN_DOCUMENT_ITEMS_TABRATE = 0
IN_DOCUMENT_ITEMS_TABPRICE_UNIT = 0
IN_DOCUMENT_ITEMS_TABCOND_UNIT = €€€
IN_DOCUMENT_ITEMS_TABREQ_DEL_DT = 06/12/2006



Cause

This problem occurs due to a character translation issue.

Answer

To correct the problem you must set the SAPReadCodePage to LCSTREAMFMT_NATIVE as documented in the IBM Lotus Connector for SAP Solutions Version 1.7.2 Release Notes. The relevant excerpt from that Release Notes (readme.txt) is as follows:


    "The internal format for text in the SAP connector for scripts (LSXLC) is now by default UTF8. For non-UNICODE systems, this may cause character corruption. To fix this, set your LCConnection object for SAP property SAPReadCodePage to LCSTREAMFMT_NATIVE. This is the default format used in SAP connection documents for LEI and DECS, for all platforms except i5/OS, where the default is LCSTREAMFMT_IBMCP819, which corresponds to US ASCII."


    Cross reference information
    Segment Product Component Platform Version Edition
    Messaging Applications IBM Domino Lotus LSX Toolkit

Rate this page:

(0 users)Average rating

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

Lotus Connector for SAP Solutions

Connector - General


Software version:
1.7.2


Operating system(s):
Linux, i5/OS, z/OS


Software edition:
Enterprise


Reference #:
1265408


Modified date:
2010-05-25

Translate my page

Content navigation