| Author |
 Topic  |
|
|
jco510811
Starting Member
9 Posts |
 Posted - 08/21/2006 : 09:02:30
|
Hi,
Does anyone have any code that will dynamically change the collation of tables etc?
Thanks in adavance
 |
|
|
harsh_athalye
Flowing Fount of Yak Knowledge
India
5509 Posts |
Posted - 08/21/2006 : 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 Athalye
India.
"Nothing is Impossible" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 08/21/2006 : 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 Larsson
Helsingborg, Sweden |
|
|
|
jco510811
Starting Member
9 Posts |
Posted - 08/21/2006 : 09:36:41
|
hi,
Thakns for this - is there any chnace to can tell me how to do at db level?
Thanks |
|
|
|
harsh_athalye
Flowing Fount of Yak Knowledge
India
5509 Posts |
Posted - 08/21/2006 : 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 Larsson
Helsingborg, Sweden
oh, Yes....Sorry Peter, you are right...I had something else on my mind !
Harsh Athalye
India.
"Nothing is Impossible" |
|
|
| |
Topic |
|
Dynamic Collation Query
