Topics

In R4, the view column properties "Case sensitive sorting" and "Accent sensitive sorting" meant if two strings were the same without regard to case or accent, then the case and accent would be used to try to differentiate them. This meant that most of the time, case and accent-sensitive sorting was not used.

In R5, the two properties mean to sort with regard to case and accent all the time. This is fundamentally different than it was in R4. For this reason, an R4 database converted to R5 defaults to not having the properties selected.