The order should reflect the encoding of the characters. Chinese characters are supported in two ways: via UTF-8 encoding (the default) and UCS2 encoding (which you get by specifying CHARACTER SET UCS2 in the column definition). So, when issuing ORDER BY, the order you get will be either UTF-8 ordering or UCS2 ordering. If I recall correctly, the mapping between UTF-8 and UCS2 encodings preserves order; in which case the order will be the same for both.
From: Anoop Sharma [mailto:[email protected]] Sent: Thursday, May 18, 2017 7:08 AM To: [email protected] Subject: RE: [Question]Does Trafodion support order by Chinese character? traf characters will be compared using binary collation based on the contents of column ‘a’. If some other non-binary collation is needed to correctly order chinese characters, then that is not supported. Can you run a query comparing these characters and see if the comparison is correct. Something like: select a from t11111 where string1 < string2 (here string1, string2 are Chinese character strings and string1 should collate lower than string2 in Chinese characters) anoop From: Liu, Yuan (Yuan) [mailto:[email protected]] Sent: Wednesday, May 17, 2017 11:23 PM To: [email protected]<mailto:[email protected]> Subject: [Question]Does Trafodion support order by Chinese character? Hi, I’d like to ask a quick question here: Does Trafodion support order by Chinese characters? For example, SQL>select a from t11111 order by a; A ---------------------------------------- 他 你 我 --- 3 row(s) selected. It seems the result is not correct. Can anyone help confirm? Best regards, Yuan Email: [email protected]<mailto:[email protected]> Cellphone: (+86) 13671935540
