Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • Last Modified:

SQL Server 2008 Collation

I am installing SQL Server 2008 and for the collation i want to choose Latin1_General_CI_AS but on the drop down I don't have that option (see attached document).  How can i determine which selection will give me Latin1_General_CI_AS.
0
gloyola1
Asked:
gloyola1
  • 2
  • 2
1 Solution
 
cyberkiwiCommented:
See attached document?
0
 
gloyola1Author Commented:
0
 
cyberkiwiCommented:
When you are up to step Server Configuration at the left, to to the 2nd tab Collation on the right

Click Customize against Database Engine

Click the top option "Windows.."

In the list, drop down to "Latin1_General"

CI = leave Case-sensitive unticked
AS = tick Ascent-sensitive

Click OK
0
 
gloyola1Author Commented:
Thanks, that is what I needed.  Wow, I have been struggling for a while on this.  It sure was not very intuitive.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now