Archives of the TeradataForum

Message Posted: Wed, 02 Mar 2005 @ 19:00:07 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

David,

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.

Thanks,

Bob Diehl
Travelcoity.com

	<Prev	Next>		<<First	<Prev	Next>	Last>>