Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

mssql 2008 collation, no utf-8?

Posted on 2013-12-02
3
Medium Priority
?
1,322 Views
Last Modified: 2013-12-10
Hi;

I need to setup a database of MSSQL 2008, and need to set a collation. Yet, I couldn't find utf-8 option in it?

What is the broadest collation that I can go for so that I won't have headaches in terms of it in future?

Regards.
0
Comment
Question by:jazzIIIlove
  • 2
3 Comments
 
LVL 41

Expert Comment

by:Kyle Abrahams
ID: 39690059
There is no "broadest collation".  

See this link for more info:
http://technet.microsoft.com/en-us/library/ms143726(v=sql.100).aspx

Essentially collations provide the rules that help you sort your data.  You can change it on the fly later, but it really depends on your business logic.
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 39690075
Hi;

Is charset or globalization important in this? I don't know which questions I should ask in this case? Can you help me by asking? Do you plan to have this or that in database? Hmm..

The database will contain major nordic country charsets.

Regards.
0
 
LVL 41

Accepted Solution

by:
Kyle Abrahams earned 2000 total points
ID: 39691094
Hi Jazz,

Globalization is important in this.  

Even though this is for mysql this demonstrates what the effects of different collations are:
http://dev.mysql.com/doc/refman/5.0/en/charset-collation-effect.html

And here is a post that is close to yous in terms of what collation to select in Scandanavien countries:
http://dynamicsuser.net/forums/p/20679/95573.aspx

Again, just because you choose one collation now doesn't mean you're forced into that path.  You can change it later on if you find out it's not the optimal one for you.

Questions I would be asking are what types of languages / character sets they plan on storing as nvarchars in the db.  Is there any plan for expansion?
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

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…
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.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

971 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