Archives of the TeradataForum

Message Posted: Thu, 02 Dec 2004 @ 22:15:45 GMT


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

Subj:		Bad Characters

From:		Claybourne Barrineau

All,

I have some bad characters (Hex value 'A0') in my data. These characters look like spaces (hex value '20'), however, they aren't and they are causing 2 values (which look identical) to hash differently.

My question is as follows: Why is Hex Value 'A0' allowed in a field defined as 'Character Set Latin'? Is their a way to prevent this stuff from getting loaded via SQL?

Thanks,

Clay