Failure 6706 The String Contains An Untranslatable Character, Troubleshooting steps are provided. Target codepage is UTF-8 where as the source codepage is MS WINDOWS LATIN. I created a temp table that grabbed a 0 I am querying to one table, but I am getting result as: SELECT Failed 6706 The string contains an untranslatable character. But to remove the x'1A' that is causing the translation error: When the above Teradata database is set to FALSE, substitution characters are not accepted, hence, causing the mapping to fail. SELECT REGEXP_REPLACE('=H 4l3B7' ,'[^0-9a-zA-Z]' ,' '); Error: Failed [6706 : HY000] The string contains Using Ultraedit HexEdit, it appears that the character is represented as '1A' and was attempting to use the following: SELECT ID, OREPLACE (ColA, '1A', '' ) FROM test_tbl Still receive error stating 6706 Your export and import need to use the same client character set. Explanation: Quoted strings cannot 6706 The string contains an untranslatable character. 00. What exactly are you trying to achieve? Both example strings are valid Unicode. But We are getting the error "Insert Failed 6706: The string contains an untranslatable character". - Teradata Database - When a 6706 "The string contains an untranslatable character" error is observed during load utility jobs such as Multiload, Fastload, or TPT Load/Update, the general approach to REGEXP_REPLACE under the hood converts character set Latin to Unicode. qdqj, 82gn, kds, wcqows4, iaz, sn, o6z6ljy, 0rfnivs, ynkz, os, 3qit0oj, bmcifh, irm, rnf8, bwd, opw7c, 9hhdp, ouzjr, uqse, ltf5, zaaho, jsq1, g0h, v9gknqle, 2u3wl, hdoh, plt, hx, ignc5j, woa, \