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 |
|
jco510811
Starting Member
9 Posts |
 Posted - 2006-08-21 : 09:02:30
|
Hi, Does anyone have any code that will dynamically change the collation of tables etc?Thanks in adavance |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-08-21 : 09:24:14
|
| Why do you want to do this? You will have to change collation for every character column of the table...If you want to do this for each table, better change collation at DB level, changing collation only for some table is to be with extreme care and avoided as far as possible.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-21 : 09:26:44
|
| Does changing the collation for the database, really change all the already created tables and column too? Or is it only added tables and columns thereafter that inherits the new collation?I am sure there are many topics about changing collation at this forum.Peter LarssonHelsingborg, Sweden |
|
|
|
jco510811
Starting Member
9 Posts |
Posted - 2006-08-21 : 09:36:41
|
| hi,Thakns for this - is there any chnace to can tell me how to do at db level?Thanks |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-08-21 : 10:38:52
|
quote:
Originally posted by Peso
Does changing the collation for the database, really change all the already created tables and column too? Or is it only added tables and columns thereafter that inherits the new collation?I am sure there are many topics about changing collation at this forum.Peter LarssonHelsingborg, Sweden
oh, Yes....Sorry Peter, you are right...I had something else on my mind !Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
|
|
|
Dynamic Collation Query