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.
SAP Knowledge Base Article - Preview