Solved

Character Set and Sort Order

Posted on 2011-09-26
5
501 Views
Last Modified: 2012-06-27
Hello Experts how would you go about finding out if these two  have been set up.


•      Character Set: 1252 Multilanguage
•      Sort Order: Accent-insensitive, case-insensitive

I am installing a new application and these need to be set up before I can move on.   Please help
0
Comment
Question by:algotube
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 23

Expert Comment

by:wdosanjos
ID: 36601033
Please try:

Select
SERVERPROPERTY ('Collation') Collation,
SERVERPROPERTY ('SqlCharSetName') SqlCharSetName,
SERVERPROPERTY ('SqlSortOrderName') SqlSortOrderName
0
 
LVL 40

Accepted Solution

by:
lcohan earned 350 total points
ID: 36710529
Usualy the COLLATION name give you the brief description of what you need - for instance:

SQL_Latin1_General_CP1_CI_AS means

Latin1 - is code page 1252 installed - see link : http://msdn.microsoft.com/en-us/library/Aa214408
CP1 specifies code page 1252
CI is Case Insensitive
AS is Accent Sensitive

Based on these you would need something like:  SQL_Latin1_General_CP1_CI_AI
http://msdn.microsoft.com/en-us/library/ms180175.aspx


0
 

Author Comment

by:algotube
ID: 36711722
wdosanjos;

    It give me the Collation type but no character set or sort order...........

Latin1_General_CI_AS      iso_1      bin_ascii_8
0
 
LVL 40

Expert Comment

by:lcohan
ID: 36711816
Latin1_General_CI_AS  is the default collation for Windows U.S. English locale and is that what you see under SQL Server Properties??
Regardless of the difference it looks like you have Accent-Sensitive/Case-Insensitive and not the desired "Accent-insensitive, case-insensitive"


Good luck!
0
 

Author Closing Comment

by:algotube
ID: 36712018
Perfect thank you so much for your reply..........
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question