Solved

Character Set and Sort Order

Posted on 2011-09-26
5
496 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
ID: 36601033
Please try:

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

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 39

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

773 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