Wrong ordering

lubost
lubost Member Posts: 633
in SQL General
SQL Server configured to use collation Latin1_General_CS_AS. NAV use Code(20) type column in primary key and SQL and NAV produces following wrong order:
HUTNY-MATE-POLYESTER
HUTNY-MATERIAL-PZN
HUTNY-MATE-W.15,WPA

where HUTNY-MATE-W.15,WPA should be ordered before HUTNY-MATERIAL-PZN.

What is the reason or what is wrong?

Answers

  • vaprog
    vaprog Member Posts: 1,161
    Well, "Wrong" in this case is up for debate ...

    Anyway, "What you are seeing here is that the hyphen, due to being between letters, is ignored"

    found on this StackExchange page

    Unicode collation rules are complicated!

Categories