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