SAP Knowledge Base Article - Preview

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

Symptom

  • On a database using UTF8BIN collation, when comparing a date column with a string containing 'September':
    select * from tab1 where datecol = 'September 25 2021'; 
  • 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"


Read more...

Environment

SAP IQ 16.1 SP04

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 , Known Error

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.