Hi,

Is there a way to specify the collation in an iGrid sort method?

In my MS Access project, I change the collation of the database depending on the user's language. For example, for English-speaking users the db is set to dbSortGeneral, but for Swedish users it is set to dbSortSwedFin. (Swedish alpha sorting rules are different from English...)

The MS collation settings are here .

Is there a way to specify the collation rules when sorting text in iGrid?

Thanks,
Alex

I just realised iGrid is sorting based on the PC regional settings.

That will be OK for me most of the time, but still would be useful to know if there is a way to override the collation that iGrid is using in igSortByValueGeneral.

Thanks!

You can't do this for the default igSortByValueGeneral sort type, but you can write your own sort algorithm using custom sorting.

See the igSortCustom sort type and the accompanying CustomSort event.