Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
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