SQLServerException: Invalid column name 'pzuserid'
Pega Installation displays an error when installing Turkish Collation.
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'pzuserid'.
Steps to Reproduce
Install Pega with Collation selected as Turkish_CI_AS.
The issue occurred due to how 'i/L' is handled in Turkish Collation. The Pega Install script is in English. Therefore, it handled the 'i/L' characters incorrectly.
Currently, Turkish Collation is not supported during Pega installation.
Perform the following local-change:
Change the column type to Nvarchar for the Custom class which contains Unicode characters.