Solved

Character Set and Sort Order

Posted on 2011-09-26
5
492 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
  • 2
  • 2
5 Comments
 
LVL 23

Expert Comment

by:wdosanjos
Comment Utility
Please try:

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

Accepted Solution

by:
lcohan earned 350 total points
Comment Utility
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
Comment Utility
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 39

Expert Comment

by:lcohan
Comment Utility
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
Comment Utility
Perfect thank you so much for your reply..........
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now