otranslate UDF returns nulls when hexadecimal values are used

Extensibility
Enthusiast

otranslate UDF returns nulls when hexadecimal values are used

Hi,

 I am using OTRANSLATE UDF to remove control characters.I am using it in the following format

OTRANSLATE(COLUMNNAME,'09'XC'0D'XC'20'XC,'|||')

I am trying to replace Tab,Carriage return and space with pipe symbol.It seems to work fine in my SQL assistant ,but when i test it on production data using another SQL Assistant null values are returned.I am sure that this column has data,still it is returning null values.

The session characterset is ASCII in both cases. 

The column is declared as LATIN characterset in DDL.

Does this cause the UDF to return NULL values?

Should I use Translate function in Teradata to change the characterset

Please reply its quite urgent

Thanks,

Vijayshankar