Sorting appears to be case sensitive for text data sorted via query rules or the

lindat over 10 years ago

Sorting appears to be case sensitive for text data sorted via query rules or the SortInfo data type. In my paging grids, case insensitive sorting would be more usable. What is the recommended approach for accomplishing this?...

Discussion posts and replies are publicly visible

Parents

0 Tim
Certified Lead Developer
over 10 years ago

This can most probably be controlled at a database level. By default your RDBMS is probably set to use a Binary sorting method which is the quickest way for the database to sort but it is also case-sensitive. I know that both SQL Server and Oracle have parameters to control which sort method is used. You should speak to your DBA about this.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Tim
Certified Lead Developer
over 10 years ago

This can most probably be controlled at a database level. By default your RDBMS is probably set to use a Binary sorting method which is the quickest way for the database to sort but it is also case-sensitive. I know that both SQL Server and Oracle have parameters to control which sort method is used. You should speak to your DBA about this.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data