Unicode vs Latin

Database
Enthusiast

Unicode vs Latin

Hi,

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,

Raja

4 REPLIES
Teradata Employee

Re: Unicode vs Latin

Hi,

you can use UNICODE for user data as well, this can be specified for CHAR/VARCHAR columns in CREATE TABLE statements.   

Regards,

Vlad.

Enthusiast

Re: Unicode vs Latin

I know that it can be done but my question is something different.

Thanks,

Raja

Supporter

Re: Unicode vs Latin

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. 

Enthusiast

Re: Unicode vs Latin

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.