otranslate UDF returns nulls when hexadecimal values are used
I am using OTRANSLATE UDF to remove control characters.I am using it in the following format
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