Insert ASCII 222 value

Database
Enthusiast

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 (1)
3 REPLIES
Senior Apprentice

Re: Insert ASCII 222 value

Only hex '1A' will result in an error, but 222 should work

What did you try?

SELECT CHR(222), 'DE'xc

Enthusiast

Re: Insert ASCII 222 value

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

Senior Apprentice

Re: Insert ASCII 222 value

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.