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 |
|
forum1
Starting Member
1 Post |
 Posted - 2007-06-23 : 17:35:16
|
I use this to change the callation of all tables in databaseALTER DATABASE namedb COLLATE Cyrillic_General_CI_AS but stiil when I inert new value in russuian I get ??? in data grid information.Why that?What is the point of this command "ALTER DATABASE namedb COLLATE Cyrillic_General_CI_AS", becouse don't have any good calation efect.I use MSSQL 2005 workgroup edition. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-23 : 22:10:41
|
| You may need use unicode data type. |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-06-25 : 11:06:31
|
| The command only affect FUTURE columns in your database....ine effect your changing the default value for the DB.I think you need to run a convert script to change any existing collations. There was a topic here recently on an exercise to do this.....(go search) |
|
|
|
|
|
|
MSSQL COLLATE