Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Specifying A Database Collation



The Jet Data Manager has the ability to change the collation of the staging, data warehouse, and OLAP databases. As a best practice, the collation of all three databases should be set to the same collation setting.

Note: As a best practice the collation of all three databases should be set to the default collation that is set for Analysis Services.

How to Specify the Database Collation

1. Right-click the database you would like to specify the collation for and select " Edit "

2. From the Collation drop-down, choose the desired collation;

a. <Application Default> will use Latin1_General_CI_AS as the collation setting
b. <Server Default> will inherit the collation of the specified server
c. Alternatively, choose a collation setting from the drop-down list

3. Click OK .


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments