Symptom
Intractive SQL Utility(dbisql) cannot convert Japanese Shift_JIS strings to EUC-JP, when Client locale is Windows-31J or Ja_JP.sjs.
Conversion error occuerd at client side.
(dba)> insert into euc_tab values(1,'全員')
Could not execute statement.
Syntax error or access violation
SQLCODE=0、ODBC 3 STATE="42000"
Line 1、Column 1
insert into euc_tab values(1,'全員')
This error occurs in the following combination and is not dependent on the OS.
- SAP IQ Server Collation: EUC_JAPAN(EUC-JP)
- SAP IQ Network Client locale: Windows-31J(MS932)
As a result, dbisql fails to convert certain characters.
For example, if the low byte of 2 byte code of EUC-JP is in the following range, dbisql will cause an error.
- EUC-JP [0xE0~0xFC]
Read more...
Environment
- SAP IQ 15.4
- SAP IQ 16.0
- SAP IQ 16.1
Product
Keywords
SAP IQ, Intractive SQL, dbisql, Japanese, sjis, shift-jis, euc, eucjis, euc-jp, euc-jis, windows, linux, solaris, conversion, violation , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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.