Archives of the TeradataForum

Message Posted: Mon, 06 Oct 2008 @ 16:06:57 GMT

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

<-- Anonymously Posted: Mon, 6 Oct 2008 20:31 -->

Hi,

I want to clarify that if a character takes 1 char in sql server that should also only take 1 char in teradata?

For one of the column /column_name/, we have a control character issue. On the SQL side we have the value column_name='1234567890- =~!@$ÿ()qwertyuiopÿÿ\QWERTYUIOP{} * asdf*. On the Teradata side we have the value column_name= '1234567890-=~!@$ÿ()qwertyuiopÿÿ\QWERTYUIOP{} *a*. This column is of type varchar(50). The control character 'ÿ' in SQL side has length '1' while the corresponding control character 'ÿ' in Teradata side has length '2'. Due to this column_name value exceeds column length and results in truncation of data.

Thanks

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