16.20 - KANJI1 Restrictions - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine International Character Set Support

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
User Guide
featnum
B035-1125-162K
In accordance with Teradata internationalization plans, KANJI1 support is deprecated and is to be discontinued in the near future. KANJI1 is not allowed as a default character set; the system changes the KANJI1 default character set to the UNICODE character set. Creation of new KANJI1 objects is highly restricted. Although many KANJI1 queries and applications may continue to operate, sites using KANJI1 should convert to another character set as soon as possible.
Upon upgrading to Teradata Database 14.0 or greater, the system automatically replaces DEFAULT CHARACTER SET KANJI1 with DEFAULT CHARACTER SET UNICODE in existing user definitions.
As part of the plans for discontinuing Kanji1 support, the creation of new Kanji1 objects is highly restricted. Inclusion of the phrase CHARACTER SET KANJI1 in the following statements returns a syntax error:
  • CREATE USER/MODIFY USER
  • CREATE TABLE/ALTER TABLE
  • CREATE FUNCTION/REPLACE FUNCTION
  • CREATE TYPE/ALTER TYPE
  • CREATE PROCEDURE/REPLACE PROCEDURE
  • CREATE MACRO/REPLACE MACRO
  • CREATE VIEW/REPLACE VIEW
  • CAST function

Plan to use the TRANSLATE function to convert existing Kanji1 data to Unicode or another supported server character set. For details, see “TRANSLATE” in Teradata Vantage™ SQL Functions, Expressions, and Predicates, B035-1145.