Article - CS20723
About Microsoft SQL Server Collation settings in Windchill
Modified: 28-Oct-2025
Applies To
- Windchill PDMLink 8.0 to 13.1
- FlexPLM 11.0 to 12.0
- Microsoft SQL Server
Description
- About MS SQL Server Collation settings
- Can Windchill PDMLink be installed on an MS SQL Server instance which has a collation other than SQL_Latin1_General_CP1_CS_AS, for example SQL_Latin1_General_CP1_CI_AS?
- Can Windchill PDMLink be installed on an MS SQL Server instance which has a collation other than Latin1_General_100_CS_AS_SC, for example SQL_Latin1_General_CP1_CI_AS?
- Is it sufficient to set the Windchill database collation to SQL_Latin1_General_CP1_CS_AS, even though the MS SQL Server instance has a different collation?
- How to determine the collation of a given MS SQL Server instance?
- Can the collation Latin1_General_100_CS_AS_SC be changed after Windchill Installation?
- Which collation is required for Windchill Business Reporting (Cognos)?
- Which collation is required for PTC System Monitor (PSM)?
- Can 2 different Windchill version instances shared the same SQL Server instance ?
- Possible error messages:
- MethodServer.log reads:
Nested exception is: java.sql.SQLException: [ptc][SQLServer JDBC Driver][SQLServer]Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CS_AS" in the equal to operation.
- PTC Solution Installer (PSI) reports:
Failed to validate SQL Server master database collation as 'SQL_Latin1_General_CP1_CS_AS'. Windchill requires SQL Server SQL Collation 'Directory order, case-sensitive, for use with 1252 Character Set'. Please re-configure the SQL Server Instance with Collation 'SQL_Latin1_General_CP1_CS_AS'. *SQL Server DNS Registered Host Name: Installed SQL Server Instance Name (Named Instance)
This is a printer-friendly version of Article 20723 and may be out of date. For the latest version click CS20723