Saturday, February 9, 2013

Failed. 6706: The string contains an untranslatable character


Problem Description: SELECT Failed. 6706: The string contains an untranslatable character

This error usually comes when a junk character come across when selecting from column of a table using some function like cast (), coalesce(),trim() etc.

Example :

 Select Prop_Name, cast(coalesce(Prop_DSC,'') as char(400) ) from P_PROPERTY. PROPTYPE ;

Problem seems to be with data in column "Prop_DSC" in P_PROPERTY. PROPTYPE  table. column character set is LATIN.

Problem Solution:  Please use translate_chk function to determine untranslatable column values that are causing this issue

You can use the proper “source_TO_target”  value for the translation. e.g. LATIN_TO_UNICODE
please check “show table” to verify any character set is specified for column in table definition and choose character set translation string accordingly e.g. LATIN_TO_UNICODE, UNICODE _TO_ LATIN etc .

SELECT Prop_DSC  FROM P_ PROPERTY.PROPTYPE  WHERE TRANSLATE_CHK(Prop_DSC USING LATIN_TO_UNICODE) <> 0;


4 comments:

  1. Thanks for great information you write it very clean. I am very lucky to get this tips from you


    Warehouse distribution services

    ReplyDelete
  2. Very nice and useful information. Thanks for sharing.

    ReplyDelete
  3. Very helpful.. Keep posted such stuff .

    ReplyDelete
  4. very very helpful. Thank you.....

    ReplyDelete