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

Search for additional results

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