SAP Knowledge Base Article - Preview

2736019 - dbisql cannot convert Shift_JIS(CP932) strings to EUC-JP - SAP IQ

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

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0 ; SAP Sybase IQ 15.4 ; SAP Sybase SQL Anywhere 12.0

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.