Archives of the TeradataForum

Message Posted: Tue, 19 Dec 2006 @ 16:59:26 GMT

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

<-- Anonymously Posted: Wednesday, January 21, 2004 07:04 -->

Character string comparisons, equality as well as ordering, depend on the SESSION COLLATION setting. CASESPECIFIC or NOT CASESPECIFIC (case- blind) are actually modifiers to COLLATION not CHARACTER SET. Use SHOW SESSION to see what collation is in effect. See the chapter on Collation Sequences in the International Character Set Support manual for more detail.

And the actual data values stored in the UNICODE column will depend on SESSION CHARACTERSET of the session doing the INSERT VALUES so you have to be careful there as well.

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