Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
steve65
Starting Member
5 Posts |
 Posted - 2007-07-26 : 15:26:54
|
| Hello All,I two different applications that I would like to use the same SQL server for, however the problem I am having is, is that one application wants to have a database with the dictionary order, case-sensitive and the other application wants to have the dictionary order set to case-insensitive.Is there a way to have these two different dictionary orders on the same MSSQL server?Thanks Steve |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-07-26 : 15:48:20
|
| when you create the database you can select the collation you want that database to use. This can be different than the default collation you set when SQL Server was installed.-ec |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-26 : 16:23:00
|
| and if you can't change the collations you can always specify which collation to use in yourstatements with the keyword COLLATE nameOfCollationHere_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
steve65
Starting Member
5 Posts |
Posted - 2007-08-06 : 09:30:49
|
| Sorry it took so long for me to get back to you. Thank you for the help I will give it a try. |
|
|
|
|
|
|
Dictionary Order