All Forums Database
Raja_KT 1246 posts Joined 07/09
23 Jul 2013
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

Raja K Thaw

My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1

Street Children suffer not by their fault. We can help them if we want.

VBurmist 96 posts Joined 12/09
23 Jul 2013

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

Raja_KT 1246 posts Joined 07/09
24 Jul 2013

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

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

ulrich 816 posts Joined 09/09
24 Jul 2013

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. 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

JPawling 3 posts Joined 08/05
24 Oct 2013

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.

John

You must sign in to leave a comment.