Author Topic: Case sensitive sorting  (Read 523 times)

skiwi

  • EA Practitioner
  • ***
  • Posts: 1933
  • Karma: +42/-82
    • View Profile
Case sensitive sorting
« on: May 26, 2020, 01:23:08 pm »

It does my head in when I use diagram layout with the Sort Name (ascending) and find the the sort is case sensitive.


This isn't the way the real (e.g. business) work works, and certainly sin't what my users expect in documentation.


Any way of changing this so sorting is case (and accent) insensitive?
(and its not related to the Database collate sequence which is set to case and diacritic insensitive)
Orthogonality rules
Using EA15.2 (1555) on Windows 10 Enterprise/64 bit. Repositories in SQLServer2019 & Access2003/JET4.0. WebEA on Pro Cloud Server 4.2.64

qwerty

  • EA Guru
  • *****
  • Posts: 12087
  • Karma: +336/-278
  • I'm no guru at all
    • View Profile
Re: Case sensitive sorting
« Reply #1 on: May 26, 2020, 03:41:57 pm »
It's the collation of the DB. Probably you can change it there (or your DBA can do so).

q.