Diagram layout: sort

[skiwi]

I was laying out a diagram, sort by name ascending.
Then puzzled why the results were not alphabetically sorted.

Then I realised the results are case sensitive. EAUI in spades.

By all means provide a case sensitive sort, but please don't make it the default and only option.
When was the last time you saw a sort or dictionary in case sensitive order?

[qwerty]

IIRC case sensitivity is something brought in by the RDBMS. ICR which, but EAP, MySQL and MS SQL Server have either. The question is: should EA put a layer over that mechanism and force sorting to be this or that way (like in your glossary example)? I guess that nobody put that card in the game so far?!

q.

[skiwi]

Well in SQL-Server at least both the EQUALS operator and the LIKE operator are case insensitive, at least with some of the the default collation sequences (CI AS).
Or you can simply say SELECT ... COLLATE Latin1_General_CS_AS.

Certainly your average business owner, looking at something that is sorted case sensitively would wonder about whether us architects are on the same planet, IMHO.  

Me, I'd like to see a global option that can trun case sensitivity off.

[qwerty]

You know how to write feature requests

So most likely it's MySQL which is case sensitive (since EAP is from the same stall as MS SEQL Server).

q.

[skiwi]

I do, lol.

Interesting that some lists are sorted case insensitively


Its that koncis consistency that gets me.

[qwerty]

Those lists are sort "internally" and do not get cooked by the RDBMS. Konzisdend.

q.

[AndyJ]

qwerty, this inkonsident spellerating is going to make my head asplode!