troubleshooting Question

SQL Collation vs Windows Collation

Avatar of bruno989
bruno989 asked on
Microsoft SQL Server
2 Comments1 Solution461 ViewsLast Modified:
I'm installing sql 2005 and I want to change collation so accents are insensitive.  

Question is which is better to choose at installation time:

- Windows Collation or
- SQL Collation (used for compatibility with previous version of SQL Server)

My current production server is sql 2000 running an SQL Collation (SQL_Latin1_General_CP1_CI_AS).  What throws me off is that the SQL Collation seems to say that it's for backwards compatibility and "perhaps" should not be used in future...

Database Consultant
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros