 |
 |
Archives of the TeradataForum
Message Posted: Tue, 19 Dec 2006 @ 17:52:21 GMT
| Subj: | | Re: Looking for bad data |
| |
| From: | | Victor Sokovin |
| | 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. | |
I second this and will just mention that in my session CHARACTERSET was UTF8, and COLLATION ASCII. I suspect that for Thai ASCII collation is
probably not the first choice but it did produce the results that the OP expected. I am not in a position to go try all possible combinations of
CHARACTERSET and COLLATION and will just wait for the OP to get back on this.
Regards,
Victor
| |
