I see that Teradata uses UNICODE for data dictionary tables or system tables and Latin for user data. May I know the reasons and advantages of doing this?
Thanks and regards,
you can use UNICODE for user data as well, this can be specified for CHAR/VARCHAR columns in CREATE TABLE statements.
latin is just the system default at your system if you are not specifing something in your ddl.
space savings - an unicode varchar/char will use 2 times the space.
If you don't specify a character set for a character column, it uses the default character set of the ID that created the column.
Be careful if you have any joins based on character columns to make sure both columns are the same character set, otherwise query performance can suffer.