How to check the collation which the SQL server using?



1.       In existing old server, you can login to SQL Server management studio, select the IPG main db named OCULAR3.

    Please right click it, then select Properties. A new Property window will popup.

       You can find the Collation using in the Options page inside the property window.


2.       On the new server, during the SQL server setup, in the page of Server Configuration, there is a Tab named Collation to change the collation used.

  1. In the Collation Tab, you can check the whether collation used is the exact name as that of OCULAR3. If no, you can click “Customize...” to change the collation.

Go to top