Can you please put together a test case using CQL 3 to write and read the data and create a ticket at https://issues.apache.org/jira/browse/CASSANDRA ?
Thanks Aaron ----------------- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 12/12/2012, at 11:12 AM, Wei Zhu <wz1...@yahoo.com> wrote: > I have a column family with composite column > > CompositeType(UTF8Type, UTF8Type, LongType, UTF8Type) > It stores (firstName, LastName, userID, meaningfulColumnName), if I insert > the record with foreign characters, > looks like that cqlsh -3 interprets the values wrong. I can get the values > back from Hector correctly. > > Look at the highlighted row, the column2 and column3 are reversed. > > cqlsh:XXX> select * from YYYYYY where key = 100000000; > key | column1 | column2 | column3 | column4 | value > -----------+---------------+---------------+-----------+---------+------------------------------------------------------------------------------------------------ > 100000000 | | friendlname4 | 100000004 | v | > > 333030303034403440304030402d404040667269656e646c6e616d6534 > 100000000 | afriendfname2 | afriendlname2 | 100000002 | v | > 3330303030324032403040304061667269656e64666e616d65322d40404061667269656e646c6e616d6532 > 100000000 | friendfname1 | | 100000001 | v | > > 33303030303140314030403040667269656e64666e616d65312d404040 > 100000000 | friendfname4 | friendlname4 | 100000004 | v | > > 33303030303440344030403040667269656e64666e616d65342d404040667269656e646c6e616d6534 > 100000000 | 中国人 | صباح الخير | 100000003 | v | > 33303030303340334030403040e4b8ade59bbde4baba2d40404020d8b5d8a8d8a7d8ad20d8a7d984d8aed98ad8b120 > > Thanks. > -Wei