SAP Knowledge Base Article - Preview

2708681 - A part of exported Japanese characters is garbled - SAP IQ 

Symptom

When you export data in IQ table to flat file, a part of Japanese SJIS characters may be garbled.
This issue happens when the below conditions are filled:

  • ISQL_ESCAPE_CHARACTER database option is configured as '\' (default setting)
  • SJIS character code which has '0x5C' in the 2nd byte is used as the head data of the column.
    Exception: 偆(0xed5c) and 砡(0xee5c)

Target characters which have '0x5C' in the 2nd byte

Character Character Code
0x815c
0x835c
Ы 0x845c
0x875c
0x895c
0x8a5c
0x8b5c
0x8c5c
0x8d5c
0x8e5c
0x8f5c
0x905c
0x915c
0x925c
0x935c
0x945c
0x955c
0x965c
0x975c
0x985c
0x995c
0x9a5c
0x9b5c
0x9c5c
0x9d5c
0x9e5c
0x9f5c
0xe05c
0xe15c
0xe25c
0xe35c
0xe45c
0xe55c
0xe65c
0xe75c
0xe85c
0xe95c
0xea5c
0xfa5c
0xfb5c

Read more...

Environment

SAP Sybase IQ 12.7

Product

Sybase IQ 12.7

Keywords

export, multibytes, \x5c, 5c, character code, sjis, Shift-JIS , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.