Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 18 Sep 2003 @ 11:27:59 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: UTY8713 RDBMS failure, 6706: The string contains an untranslatable character.
 
From:   Claybourne Barrineau

I think this should point out the position number of the invalid character:

Select   ColA
,     Translate_Chk(ColA using Latin_To_Unicode)
,     ColB
,     Translate_Chk(ColB using Latin_To_Unicode)
...
FRom  TableName
Where (
      Translate_Chk(ColA using Latin_To_Unicode) <> 0
or    Translate_Chk(ColA using Latin_To_Unicode) <> 0
or    ....
      )

Let me know if it works, it has been a while since I've tested this function, and I cannot seem to recreate a test set with an invalid character to prove the theory.


Hope this helps,

Clay



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023