How to identify Unreadable charecter in teradata?

Tools & Utilities

How to identify Unreadable charecter in teradata?

Hi ,

I have a requirement whic says "NULL  IF UNREADABLE" . Can anyone please help me how i can identify the UNREADABLE charecters in teradata.

thanks in advance ,

sachetan

Tags (1)
2 REPLIES
Enthusiast

Re: How to identify Unreadable charecter in teradata?

Hi Sachetan,

        You can use the SQL like  

case when translate_chk(col1 using unicode_to_latin) <> 0 then NULL else col1 end 

to nullify non-readable characters .

Cheers,

Amir

Re: How to identify Unreadable charecter in teradata?

hi Amir ,

it is working fine. thank you