How to retrieve the data and see for Blob Object column using FlexibleSearch from HAC

[Former Member]

How to retrieve the data and see for Blob Object column using FlexibleSearch from HAC

Thanks in advance.

[Former Member]

Did you ever figure out how to do this? I am facing an issue where this would be very helpful.

[Former Member]

Anyone from hybris???

[former_member620692]

In addition to the answer I have provided on this page, I have also provided the answer to another related question at https://answers.sap.com/questions/12770772/how-to-verify-whether-a-string-exists-in-string-co.html?c...

[Former Member · Accepted solution]

If we are using oracle database we can use below sql query.

SELECT dbms_lob.substr(p_endmessage,3000) FROM processes item_t0

[Former Member · Accepted solution]

Hi Vinay, Is there any possibilities to write a flexible search query for retrieving the data inside BLOB object?

[former_member620692]

With MySQL:

 SELECT CAST({urlPatterns} AS CHAR(10000) CHARACTER SET utf8) FROM {CMSSite}

With Oracle:

 SELECT UTL_RAW.CAST_TO_VARCHAR2({urlpatterns}) FROM {CMSSite}

With HANA:

 SELECT CAST(BINTOSTR(CAST({urlPatterns} AS BINARY)) AS VARCHAR) FROM {CMSSite}

Note: The SQL for MySQL and Oracle are already tested but I haven't tested the SQL for HANA yet.

[former_member624637]

Hi Arvind,

Any idea how to do this with SAP Hana?

[former_member620692]

I have updated my answer. Please do let me know if it works for you.

[former_member620692]

Hi - did it work for you?

[denisacernea]

No, for Hana I receive: FlexibleSearch query is not legal, Exception message: Invalid CESU-8 sequence