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 ONE Support launchpad (Login required).

Search for additional results

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