Announcements
No record found.
Is the following sort order supported for GP 2010:
Latin1-General, binary sort for Unicode Data, SQL Server Sort Order 30 on Code Page 437 for non-Unicode Data
Thanks.
-Warren
*This post is locked for comments
Warren,
Only two Microsoft SQL Server collation types are supported by Dynamics GP:
1.Binary—sort order 50
2.Dictionary Order, Case-Insensitive (DOCI)—sort order 52
Warren, Victoria is 100% correct.
But I would like to add that if at all possible go with option 2 "Dictionary Order, Case-Insensitive(DOCI) -- sort order 52"
My reasoning is that when using Microsoft Dynamics GP in Binary sort order the lower case letters and the upper case letters have two different binary values thus you get list and reports that places all of the Upper Case letters in one place then all the Lower Case letters in another. While most IT people understand that most Dynamics GP users are not IT people and do not understand why "BELLOWS CORP" comes before "applewhite inc."
Just my thoughts, and I hope this helps.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
