STRING_CS Usage Notes - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

STRING_CS helps determine which encoding to use when using the TRANSLATE function to translate a string from the KANJI1 server character set to the UNICODE server character set.

Result Value to Substitute for source_TO_target in TRANSLATE(string_expression USING source_to_target )
-1 KANJI1_SBC_TO_UNICODE.
0 KANJI1_SBC_TO_UNICODE.
1 KANJI1_KANJIEBCDIC_TO_UNICODE.
2 KANJI1_KANJIEUC_TO_UNICODE.
3 KANJI1_KANJISJIS_TO_UNICODE.