It's all about the answers!

Ask a question

Problem to create the database on SQL Server 2008 R2

Demi Goldberg (1156) | asked May 10 '13, 2:49 a.m.


I got an error when trying to create tables:

The database creation failed with an exception The database is not set to support case-sensitivity in string comparison operations at
Which collation do I need to use in order to create tables ?

2 answers

permanent link
Karl Weinert (2.0k52736) | answered May 10 '13, 5:53 a.m.
Here's the Setting up an SQL Server database section of the 4.0.2 information center
One of the steps is to  run:

The CS near the end is what indicates the DB should be case sensitive. (CI would indicate Case Insensitive)
I'm pretty sure that value is available from a drop down list if you are creating the database from the GUI interface.

Josh Crawford commented May 10 '13, 11:35 a.m.

I think Karl's answer is the most plausible.  But I've also seen this exception when the JDBC connection string in the file is incorrect.   For example:



instead of:

permanent link
Krzysztof Kaźmierczyk (7.4k35198) | answered May 10 '13, 3:07 a.m.
Helo Demi,
Are you using Oracle? It seems that you can find your answer here:
Let me know if it helps for you.

Best regards,
Krzysztof Kazmierczyk

Krzysztof Kaźmierczyk commented May 10 '13, 6:29 a.m.

It seems that I have answered on wrong question. Anyway I will stay this post in case someone else has this issue :)

Your answer

Register or to post your answer.