September 14, 2022 at 4:58 am
hi,
1) after changing database collation to spanish my columns are still showing latin, so i have altered all of them.
my question is should i drop my tables then recreate them or alter table alter column varcahr(100) will do?
2) So for spanish we have selected Modern_Spanish_100_ ( i think it is correct)?
yours sincerley
September 14, 2022 at 8:31 am
Depending on the databases data size, your best option is to script it all ( without collation )
As you noticed, you can alter a database default collation, but existing objects keep their original collation.
Create a new database with the correct collation and run the extracted script.
Then generate copy statements for the data ( column as new collation ).
Mind order, FK, ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 15, 2022 at 11:20 am
my second question is unanswered
September 15, 2022 at 12:14 pm
my second question is unanswered
I haven't got a clue
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 28, 2022 at 4:28 am
thank u,
on more concern i have used utf8 ,becuase i wanted to use Unicode(multilingual) so i have used Modern_Spanish_100_CI_AS_SC_UTF8
in this I have used SC also I think this combination will have all Unicode range? as my target is to have full range of Unicode in spanish language.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply