does Teradata support UTF-16 surrogate pair?

Database
Enthusiast

does Teradata support UTF-16 surrogate pair?

Environment:

  Teradata DB 15

  Executing below SQL statement

        select _UNICODE 'd835dc01'XC ;

  I got error " *** Failure 5356 One of the characters or code point does not exist within the specified repertoire."

The same error is seen both from bteq and from Teradata Studio, with session charset UTF16 or UTF8. Could somebody confirm if below things:

1) does Teradata support UTF-16 surrogate pairs?

2) does Teradata support 4 bytes UTF-8 data in the client charset UTF8?

2 REPLIES
Enthusiast

Re: does Teradata support UTF-16 surrogate pair?

More info: database/user charset is UNICODE.

Teradata Employee

Re: does Teradata support UTF-16 surrogate pair?

Teradata does not currently support surrogate code points.