Wrong ordering

lubostlubost Member Posts: 607
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:

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

What is the reason or what is wrong?


  • vaprogvaprog Member Posts: 1,092
    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!
Sign In or Register to comment.