SAP Knowledge Base Article - Preview

3392883 - Full-width minus character in collation UTF-8 - SAP IQ

Symptom

When using UNICODE such as UTF8BIN in the collation of an SAP IQ database, multiple full-width minus characters may be stored.
For example, "ー(full-width minus)" has different character codes in IBM-Unicode and MS-Unicode.
In this case, searching for MS-Unicode characters with the IBM-Unicode character code will not result in any hits.

CharacterIBM UnicodeMS Unicode
ー(full-width minus)E28892EFBC8D
―(full-width dash) E28094E28095
〜E3809CEFBD9E
‖E28096E288A5
¢C2A2EFBFA0
£C2A3EFBFA1
¬C2ACEFBFA2


Read more...

Environment

  • SAP IQ all versions

Keywords

UNICODE, UTF-8, UTF8BIN, IBM-UNICODE, MS-UNICODE, minus , KBA , BC-SYB-IQ , Sybase IQ , How To

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.