Is there a recommendation as to which collation to choose for a FSM Database running on MS SQL Server?
Userlevel 6
+23
Hi Daniel,
unfortunately, the FSM Installation Guide doesn’t include any recommendation - only for Oracle character set.
However, to my knowledge our customers usually use SQL_Latin1_General_CP1_CI_AS or SQL_Latin1_General_CI_AS for SQL Servers.
Hope that helps!
Best regards
Roman
Currently we are running FSM 6.4 on SQL Server 2016 with SQL_Latin1_General_CP1_CI_AS collation.
My DB team would like to change the collation to Windows Collations (Latin1_General_CI_AS).
Would IFS help support this collation? Is this recommended?
Userlevel 6
+23
What’s the reason for making this change? I wouldn’t recommend changing the collation, unless it’s necessary due to a well-founded reason.
Best regards
Roman
The reason DBA was exploring changing the collation is for consistancy. They would like to have all the DB using same collation (Windows default collation for Canada - Latin1_General_CI_AS).
Userlevel 6
+23
Understood. I think if you want to go 100 % sure, you should open a support ticket to get further input on possible issues.
Best regards
Roman
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.