SAP Knowledge Base Article - Preview

3243748 - On an UTF8BIN database, when comparing a date column with a string containing 'September', error "Data type conversion is not possible" is fired - SAP IQ

Symptom

The conversion error

Data type conversion is not possible. Conversion of 'September 25 2021' to data type date failed. 
-- (dflib\dfe_HDBValue.cxx 468)
SQLCODE=-1009145, ODBC 3 State="HY000"

occurs:

  • on a database using UTF8BIN collation
  • when comparing a date column with a string containing 'September': select * from tab1 where datecol = 'September 25 2021'; 

Note:

  • 'September' has 9 chars.
  • The other months are less than 8 chars and no error is fired.


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

823329, CR823329, CR#823329, UTF8BIN, September, "Data type conversion is not possible", "Data type conversion is not possible", "to data type date failed" , KBA , BC-SYB-IQ , Sybase IQ , 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.