You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Wei Zhu <wz...@yahoo.com> on 2012/12/11 23:12:01 UTC
bug with cqlsh for foreign charater
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
Re: bug with cqlsh for foreign charater
Posted by aaron morton <aa...@thelastpickle.com>.
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 <wz...@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