SAP Knowledge Base Article - Preview

2155578 - Implicit conversion from datatype 'UNITEXT' to 'CHAR' is not allowed. - SAP IQ

Symptom

ODBC error related to implicit conversion from datatype 'UNITEXT' to 'CHAR' can be reported when executing a proxy procedure from SAP IQ 15.4 to SAP Adaptive Server Enterprise 15.x:

% dbisql -c 'uid=DBA;pwd=sql;eng=iqdemo2' -nogui
(DBA)> call priq('aaaaaaaa',1,'Mar 18 2015 10:21AM','S','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','a',1,'18 2015 10:21AM',1,1,1,null)

Could not execute statement.
  Server 'srv15030': [Sybase][ODBC Driver][Adaptive Server
  Enterprise]Implicit conversion from datatype 'UNITEXT' to 'CHAR' is not   allowed.  Use the CONVERT function to run this query.
  SQLCODE=-660, ODBC 3 State="HY000"
  Line 1, column 1
  call priq('aaaaaaaa',1,'Mar 18 2015 10:21AM','S','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','a',1,'18 2015 10:21AM',1,1,1,null)
Press ENTER to continue...


Read more...

Environment

  • SAP IQ 15.4 and later

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

KBA , BC-SYB-IQ , Sybase IQ , BC-SYB-SDK , SDK , Problem

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.