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 release 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 SQL Functions, Expressions, and Predicates, B035-1145.