Archives of the TeradataForum

Message Posted: Thu, 02 Apr 2009 @ 11:19:39 GMT

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

Yes, we noticed that some time ago with regards to joining LATIN to UNICODE.

Basically, don't do it.

Solutions you might want to consider are :-

i) copy one of the tables into the other character set (but that may be a lot of data)

ii) adding another column onto the table with the other character set (but then you may have problems with Primary Index choices, and maybe column naming)

iii) change everything to Unicode (takes double the space)

iv) come up with an even better solution ... in which, please let us know.

Hope that helps

Regards

David Clough
Database Developer
Database Design Group

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