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 |
|
roshriya
Starting Member
2 Posts |
 Posted - 2008-08-20 : 06:00:50
|
| What is collation in sql 2005? |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-08-20 : 06:19:23
|
| Not sure what you mean. Can you explain a little more? Some info on collations is here: http://msdn.microsoft.com/en-us/library/ms143524.aspx |
 |
|
|
milena
Starting Member
16 Posts |
Posted - 2008-08-20 : 06:28:25
|
| If you have collation conflict you have to set all varchar fields in your database to the default collation in sql and it is :SQL_Latin1_General_CP1_CI_AS.To do that rightclick on a varchar field choose modify then in the right lower corner you will see the properties of the column.Scroll down if needed to see it Collation specified is <database default>.If it isn`t then click on the dotted square at the end , it will open up a dialog box .Choose SQL Collation and from dropdown list chose :SQL_Latin1_General_CP1_CI_AS. Click restore default and then OK.Do so for all the varchar fields in every table in the database .Sorry it is time consuming .Milena |
|
|
|
roshriya
Starting Member
2 Posts |
Posted - 2008-08-20 : 06:30:45
|
| I just needed to know what the term collate means. Thanks and got informn from the link u send. |
|
|
|
|
|
|
What is collation in sql 2005?