On the Teradata server, Unicode characters are held as UTF-16 - each character occupies 2 bytes. So in your case, NAME will occupy two bytes for the length and two bytes for each character. The field will be two bytes for a zero length string to 202 bytes for a 100 byte string.
In Teradata 13.10, there is a new algorithmic compression feature that is particularly useful for reducing the space utilization requirement for Unicode data. The actual space savings will vary depending on the specific algorithm used and on the data characteristics.
How do you set the Teradata Server for Unicode, specifically UTF-8 ? I do a query: select * from dbc.chartranslations; But I do not see any Unicode sets listed, only the standard ASCII code sets. I'm getting an error loading UTF8 data from Oracle to Teradata using DataStage ETL tool, and the Teradata TPT connector. Any ideas?