455
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, 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.
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
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
