SAP Knowledge Base Article - Preview

3043986 - SAP IQ servers with collation "932JPN" fail to convert Japanese UTF8 on Open Client connection.

Symptom

Open Client connection fails to convert data with Japanese and double-byte spaces when creating a "CHAR NOT NULL" column on an SAP IQ server with collation "932JPN"

1> select * from test1
2> go
id name1
----------- ------------------------------------------------------------
1 日本語   ・
CT-LIBRARY error:
ct_fetch(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received.

or

1> select * from test1
2> go
id name1
----------- ------------------------------------------------------------
1 12 

^Z
Suspended

1. "12" + zenkaku space
Client hangs

1> create table test1 (id int, name1 char(20) not null))
2> go
1> insert test1 values(1, 0x825082518140)
2> go
(1 row affected)
1> select * from test1
2> go
id name1
----------- ------------------------------------------------------------
1 12 

^C
^Z
Suspended

2. "日本語" + Zenkaku Space
Client error occurs

1> create table test1 (id int, name1 char(20) not null))
2> go
1> insert test1 values(1,0x93fa967b8cea8140814081408140814081408140)
2> go
(1 row affected)
1> select * from test1
2> go
id name1
----------- ------------------------------------------------------------
1 日本語   ・
CT-LIBRARY error:
ct_fetch(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received.


Read more...

Environment

  • SAP IQ 16.1
  • IQ Server collation "932JPN"
  • Open Client 16.0
  • Client Char set UTF8

Product

SAP IQ 16.1

Keywords

Japanese, sjis, 932JPN, utf8, conversion, SDK, Open Client, IQ, SAP IQ, 16, 16.1 , 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 ONE Support launchpad (Login required).

Search for additional results

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