Converting BLOB to Char in SAP HANA using SQL

I need to cast a BLOB to varchar format in HANA database using SQL query. Below is my code:

select

cast("DESCRIPTION" as varchar) "D"

from "DESC"

I get an error message: “Inconsistence datatype” as below:

Could not execute 'select cast("DESCRIPTION" as varchar) "D" from "DESC"' in 20 ms 181 µs .

SAP DBTech JDBC: [266]: inconsistent datatype:

0 0

1 Answer

SAP Expert

Answered on 6th Dec, 2017

You can perform varchar casting using following query:

SELECT TO_ALPHANUM(col) FROM ......

0 0