All Forums Database
TDUser2000 17 posts Joined 07/12
08 Oct 2014
Insert ASCII 222 value

Hello Team,
I am trying to insert the ASCII value 222 to a teradata table but it is failing with 'untranslatable string conversion' error.
 
Table -  Column Charset is UNICODE
session char set - tried with LATIN,UTF8 and UTF16.
server char set - default (LATIN)
Please suggest.
 
Regards
 

Tags:
dnoeth 4628 posts Joined 11/04
08 Oct 2014

Only hex '1A' will result in an error, but 222 should work
What did you try?
SELECT CHR(222), 'DE'xc

Dieter

TDUser2000 17 posts Joined 07/12
08 Oct 2014

Hi Dieter,
The ascii value is part of the string which i try to insert into a column. I can see the ascii 222 symbol in the input data.
 
Regards

dnoeth 4628 posts Joined 11/04
08 Oct 2014

This must be related to something else:

 BTEQ -- Enter your SQL request or BTEQ command:
CREATE MULTISET  VOLATILE TABLE vt (x VARCHAR(10)) ON COMMIT PRESERVE ROWS;


 *** Table has been created.
 *** Total elapsed time was 1 second.


 BTEQ -- Enter your SQL request or BTEQ command:
INSERT INTO vt ('bla' || 'de'xc);

 *** Insert completed. One row added.
 *** Total elapsed time was 1 second.

 BTEQ -- Enter your SQL request or BTEQ command:
INSERT INTO vt (CHR(222) || 'bla');

 *** Insert completed. One row added.
 *** Total elapsed time was 1 second.

 BTEQ -- Enter your SQL request or BTEQ command:
INSERT INTO vt ('bla' || '1a'xc);

 *** Failure 6706 The string contains an untranslatable character.
                Statement# 1, Info =26
 *** Total elapsed time was 1 second.

 

Dieter

You must sign in to leave a comment.