Chinese characters sorting

[#1]

Hi! I'm from china!

Recently I found an interesting thing.I have two operation system,one is English and the other is Chinese! When I do the sort operation with the same qvw file in this two system.I got a different thing.

pic 1:this one is in the english system and is wrong

Pic 2: this is in the chinese system and is right.

Can anyone help me ?

[#2]

Don't think you can expect chinese charachters to be sorted correctly in an english based setting. Perhaps you could explicitly map the sort order in the loading part of the script.

/Michael

[johnw]

On my English copy of QlikView, it says that sorting is done by the ASCII standard. That wouldn't work for Chinese Characters, which I assume are in UTF-8?

Now, I would have THOUGHT that QlikView would be smart enough to realize that if you loaded a table in UTF-8, that you want to sort by UTF-8 as well. But maybe it isn't, and the help text seems to indicate that it isn't. I suppose it isn't technically a bug in that case, since it is working as stated, but it sure seems like a missing feature!

Michael's solution sounds reasonable to me. As I interpret it, you would add a "MajorCategoryNameSequence" field during the load. As long as you do the load in the Chinese system, I would expect you to be able to establish this field correctly. Then I believe you should be able to enter "MajorCategoryNameSequence" as the default sort expression for "MajorCategoryName". I suspect it would work.

Edit: Or you could use the dual() function to assign the sequence number directly to the MajorCategoryName. Then just sort by numeric instead of by text value.

[#4]

Thanks John!

This is real interesting that I got correct in my Chinese system but wrong in the English system with the same qvw file!