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 for Me (Login required).

Search for additional results

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