Truncation Examples - Teradata VantageCloud Lake

Lake - Database Reference

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

Consider a string containing a half-square Katakana and a Kanji character ア 山 (the half-square Katakana 'a' followed by the Kanji 'yama' for mountain) stored in a column declared as CHAR(3) CHARACTER SET KANJISJIS. The VantageCloud Lake representation of the string is:

B1 8E 52

If the column is exported from a UTF8 session, the export width rule is n (n character in the column produces n bytes as output), the following data is exported (observe that ア expanded to three bytes, so truncation at the logical character boundary occurred between ア and 山 so no padding is required).

EF BD B1