How to remove Null charactors in Input data from Oracle database?

[Yoshiro_Fujimori]

Dear community members,

I have Oracle database connected to Alteryx Designer.

Using Input Data tool, I tried to get data from a CLOB field in a table on the database,

with SQL such as;

select CLB.REC_ID,
       CLB.xxxxxxxx,
       CLB.GET_DATE,

       to_char(CLB.ORG_REC)
from   xxxxxxxx.xxxxxxxx CLB
where  CLB.REC_ID = '000000123456789'
   and CLB.TOPIC_ID in ('ABC123456789012')
   and CLB.GET_DATE >= '2023-01-25'
   and CLB.GET_DATE <= '2023-01-25'
   and RowNum <= 1000

The data output from Input Data tool shows the string size is 32767 bytes.

However, when I pass the data to other tools it has only 27 bytes.

It seems the original CLOB data contains Null charactor, which is treated as the end of a string.

I suppose I need to change my SQL to replace Null charactor with something else (say white space).

Any advise to achieve this would be appreciated.