April 15, 2015 at 9:15 am
Hi,
I am doing a SQL Server installation for an antivirus application. The requirements are as follows: What options do I need to chose during installation in the collation window?
Database collation McAfee ePO software supports all Microsoft SQL Server collations using the
following two SQL collation properties:
• Case Insensitivity (CI)
• Full ASCII character set support (this is included in all Unicode-based
character sets)
April 15, 2015 at 11:37 am
Sounds like the default will be fine. Do you normally change the collation?
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 15, 2015 at 11:41 am
The default of SQL_Latin1_General_CP1_CI_AS should most likely be used.
This McAfee KnowledgeBase article seems to echo that: https://kc.mcafee.com/corporate/index?page=content&id=KB73717
Twitter: @SQL_JGood
Blog: sqljgood.wordpress.com/[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply