cancel
Showing results for 
Search instead for 
Did you mean: 

Why on earth doesn't HANA BINTOTEXT() work on STXL.CLUSTD

peter_schubert314
Discoverer

I've seen many posts asserting that SAP binary text can't be read in HANA. I haven't found the reference, but I suspect STXL.CUSTD is some other protocol than CESU-8, which is what HANA BINTOTEXT() requires.

I've tried many, many combinations of conversion functions (SQL in HANA Studio), and am tantalized by the idea that the exact combination will open the treasure chest.

Anybody had success in this forest?

Here are a sample of three trials

  1. SELECT BINTOSTR(TO_BINARY(TO_BLOB("CLUSTD"))) as EDIText

    from "SAPPRD"."STXL"

    WHERE"TDNAME" = '0030000462000010'

    /*Result: Could not complete result operation. com.sap.db.jdbc.exceptions.Cesu8ConversionException Invalid CESU-8 sequence*/

  2. SELECT BINTOSTR(TO_BINARY("CLUSTD") ) as EDIText, "CLUSTD"

    from "SAPPRD"."STXL"

    WHERE"TDNAME" = '0030000462000010'

    /*Result: executes, but null*/

  3. SELECT cast(BINTOSTR(cast(CLUSTR as binary)) as varchar) as EDIText, "CLUSTD"

    from "SAPPRD"."STXL"

    WHERE"TDNAME" = '0030000462000010'

    /*Result: executes, Integer of unknown calculation*/

Hi Peter, hope you find well.
Have you found some solution for read STXL-CLUSTD with a SQL?
I'm passing for this problem too. So, if you found a way to do it, could you share it?
Kind regards

Accepted Solutions (0)

Answers (0)