multiple SQL collation on same machine

Rakesh Kumar 456 Reputation points


Is it possible to install different collation for different SQL instances on same machine with same language.

like instance1 with Latin1_General_CP1_CI_AS


instance2 with Latin1_General_CI_AS

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,339 questions
0 comments No comments
{count} votes

Accepted answer
  1. Bjoern Peters 8,856 Reputation points

    Yes, that is absolutely possible.
    That collations are in the instance and mainly for the system databases => means that on an ideal base all your user databases have the same collation as your system databases.
    Those database collations due not really rely on the system language.

    So as you already wrote you have to install different instances on the same server if you have different collations. (technically it is possible to use different collation within one instance but it is not recommended)

    Hope this helps.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 43,166 Reputation points

    The effective collaction is defined on table-column level, so you could even have within one database different collation.

    0 comments No comments