Codejock Developer Community : Problem with sorting unicode text column

Problem with sorting unicode text column : actually this is a pain in the...

Thu, 09 Oct 2008 01:21:02 +0000

Author: adrien
Subject: 12361
Posted: 09 October 2008 at 1:21am

actually this is a pain in the neck.

You would need to subclass for all items.

It would be good if a compare func could be installed into the report control that could be used to compare strings. then this could be used to sort any field type that was a string.

Otherwise you are constantly doing sad things like...

class CXTPReportRecordItemCaseInsensitiveSortText : public CXTPReportRecordItemText
{
public:
virtual int Compare(CXTPReportColumn* pColumn, CXTPReportRecordItem* pItem)
{
return m_strText.CompareNoCase(pItem->GetCaption(pColumn));
}
};

and using CXTPReportRecordItemCaseInsensitiveSortText wherever you would otherwise use CXTPReportRecordItemText

Problem with sorting unicode text column : CXTPReportRecordItem::Compare override...

Thu, 09 Oct 2008 01:04:54 +0000

Author: adrien
Subject: 12361
Posted: 09 October 2008 at 1:04am

CXTPReportRecordItem::Compare

override this for each item in your records that you want to control sort order on.

Problem with sorting unicode text column : SetRowsCompareFunc doesn't...

Thu, 09 Oct 2008 00:48:32 +0000

Author: adrien
Subject: 12361
Posted: 09 October 2008 at 12:48am

SetRowsCompareFunc doesn't look to be much use though

since you don't get told which column is being sorted.

Problem with sorting unicode text column : It's using straight string...

Thu, 09 Oct 2008 00:47:12 +0000

Author: adrien
Subject: 12361
Posted: 09 October 2008 at 12:47am

It's using straight string compare.

I was just going to complain about this too - it should at least be doing case-insensitive sorting.

Looks like there is a func to set sort callback, so you can do your own comparison...

SetRowsCompareFunc

Problem with sorting unicode text column : Hi,there seems to be a problem...

Tue, 07 Oct 2008 13:01:27 +0000

Author: Marco1
Subject: 12361
Posted: 07 October 2008 at 1:01pm

Hi,
there seems to be a problem in sorting unicode (wide) text in a column.

A column with 500 records is filled with a presorted lastnames out of a database. No problem, sorting of mysql works fine.

If one clicks on the header of the 'lastname'-column, the sorting arrow appears and the column gets resorted by the ReportControl.

The correct order (of lastnames) returned by mysql is:
Tacke
test
Thiele
�r�n <-- Starts with german "Umlaut"
Volk
Zietlow

The ReportControl sorts like
Tacke
Thiele
Volk
Zietlow
test
�r�n

Small letters are sorted to the end, "Umlaute" (�,�,�) which must be treated as o,a,u are sorted to the end, too.
I haven't investigated further, perhaps anyone have observed/solved a similar problem?

Thanx, Marco