Thanks Dave and Anoop for your reply.
Best regards, Yuan Email: yuan....@esgyn.cn<mailto:yuan....@esgyn.cn> Cellphone: (+86) 13671935540 From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Thursday, May 18, 2017 11:24 PM To: user@trafodion.incubator.apache.org Subject: RE: [Question]Does Trafodion support order by Chinese character? 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:anoop.sha...@esgyn.com] Sent: Thursday, May 18, 2017 7:08 AM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> 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:yuan....@esgyn.cn] Sent: Wednesday, May 17, 2017 11:23 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> 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: yuan....@esgyn.cn<mailto:yuan....@esgyn.cn> Cellphone: (+86) 13671935540
