In the event of your database collation being modified, we can assist in fixing the issue.
Microsoft does not recommend changing the collation of data for Dynamics SL customers. In the event the database collation was modified in your Microsoft Dynamics SL database, Solomon Cloud Solutions provides a three-step process to fix the database collation:
Database collation serves two important roles:
The rules, that SQL Server applies when sorting and comparing characters, are strongly related to the language associated with the data. They can also specify other sorting or comparison behaviors, such as whether the sort or comparison operation is case-sensitive (_CS), case-insensitive (_CI), accent-sensitive (_AS), accent-insensitive (_AI), or width-sensitive (_WS).
Get in touch with us today for more information!
- Assess what default database collation is in place on the SQL Server.
- Assess what database collation is in place for the Dynamics SL specific databases.
- Define the proper way to change the database collation to the Microsoft supported collation, apply the changes to the database, and ensure the databases function properly within Dynamics SL after the change is complete.
Database collation serves two important roles:
- It defines the rules SQL Server applies when sorting and comparing characters in a database.
- It defines the underlying code pages used to physically store non-Unicode data (e.g., column types of char, varchar, and text).
The rules, that SQL Server applies when sorting and comparing characters, are strongly related to the language associated with the data. They can also specify other sorting or comparison behaviors, such as whether the sort or comparison operation is case-sensitive (_CS), case-insensitive (_CI), accent-sensitive (_AS), accent-insensitive (_AI), or width-sensitive (_WS).
Get in touch with us today for more information!