Archives of the TeradataForum
Message Posted: Wed, 02 Mar 2005 @ 19:00:07 GMT
I have only done research so far. SO have not found 'gothchas' yet. If all you want to do is store data in Unicode this can be done at the column level.
columnname char(5) character set Unicode
If you want to store object names a diffent language set like UTf8, then the database has to be set. This takes a sysinit to change it. This means you would have to reload your whole system. I can't remember where you set this value.
Don't forget to see what happens on translation when a query is run from a computer that has a different language set as there will be a translation performed.
Space usage and performance will be impacted depending on the language set chosen and the amount of data in multi-byte format.
Don't forget your ETL boxes also must be compliant.
You might also want to make sure you dates and numeric formats as acceptable for each nationality.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|