It is possible to truncate the output of multibyte characters in an expression with KANJI1 server character set with any of the following client character sets:
- KanjiEBCDIC
- KanjiEUC
- KanjiShift-JIS
In ANSI mode, an error occurs if a non-blank character is truncated.
In Teradata mode, the system returns the number of bytes specified and does not tell you when truncation occurs. The table below shows the hexadecimal returns. The actual return display depends on which system is used.
This character … | With this format … | Returns this value in hexadecimal … | With this character set … |
---|---|---|---|
B<AA> | 'xx' | C20E | KanjiEBCDIC |
B AA | 'xx' | 42A3 | KanjiEUC |
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.