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

On 12/12/2012, at 11:12 AM, Wei Zhu <wz1975@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