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 |
|
dvale
Starting Member
5 Posts |
 Posted - 2006-06-06 : 13:57:06
|
| Hi!I have a database in SQL Server 2005 Express edition in standard collation. And now I need to store data including letter "è" (I'm from Slovenia). Can please someone tell me how to change the collation in server and database, please?Thanks in advanced,d |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-06 : 15:07:14
|
| "how to change the collation in server"Dunno about SQL 2005, but in SQL 200 I would have said "Reinstall it". Sure there are published ways to modify the collation, retrospectively, and I did it once - and vowed to never do it again!Can you get away with just adding a COLLATE to some specific columns in the database?Kristen |
 |
|
|
dvale
Starting Member
5 Posts |
Posted - 2006-06-07 : 04:40:49
|
| There are too many columns to add collate to. If I reinstall the SQL and append the database I already have, what collation will it be in? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-07 : 05:44:01
|
| You can set the default Collation at the database level. However, if the server is different you will need to be careful that all Temporary Tables you create have explicit COLLATE statements (on char/varchar/text columns)Kristen |
|
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2006-06-07 : 12:24:23
|
| Collations follows the DB, so reinstalling and reattaching will do you no good. You can change the DB collation from SSMS, but as I recall you need to change the to one-user mode first.-- This one's tricky. You have to use calculus and imaginary numbers for this. You know, eleventeen, thirty-twelve and all those. |
|
|
|
dvale
Starting Member
5 Posts |
Posted - 2006-06-07 : 14:01:21
|
Well ... If I choose to change the collation on DB level, can you please tell me how? In properties window of the SSMS I can see the used collation (SQL_Latin1_General_CP1_CI_AS), but can't change it.thnx for all your posts Kristen and PSamsig  |
|
|
|
dvale
Starting Member
5 Posts |
Posted - 2006-06-07 : 14:03:10
|
ohh... wait a minute, I just found it ...  |
|
|
|
dvale
Starting Member
5 Posts |
Posted - 2006-06-07 : 14:11:24
|
| I just changed the collation of the databse and tryed to insert "è", but still SQL Server changes it into c...Any suggestions? |
|
|
|
|
|
|
|
|
changing the collation