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
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.