We help IT Professionals succeed at work.

Change server collation in SQL2005

751 Views
Last Modified: 2012-06-21
Hi
iam install SQL server enterprice and during install iam using collation SQL_Latin1 general
Now I want to change server collation to Arabic case insensitive How i can do that i try to uninstall all SQL and install it again but its still no change
i mean after iam after iam uninstall the old version and during new install when i reach the collation i chose Arabic case insensitive but after install complete i foud the the collation  still SQL_Latin1

how i can change server collation

thanks
Comment
Watch Question

Commented:
HI There
try this link
you have to change server collation or you can change collation on each database so it match your needs

http://msdn.microsoft.com/en-us/library/ms179254.aspx
 Best regarsd


Michael
 
Mark WillsTopic Advisor, Page Editor
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
The default "server" collation is really the collation of the master database. Bit surprised that uninstalling and re-installing doesn't change it.

So, what you are really after is chagning the default collation of the master database - you can do that without having to re-install SQL Server - but also note that if you restore any databases that they will have there own collation which maybe different again.

tje collation name you are looking for ia Arabic_CI_AS and is codepage 1256.

have a look at : http://technet.microsoft.com/en-us/library/ms143524.aspx  

For database collations, have a look at : http://technet.microsoft.com/en-us/library/ms175835.asp

For changing MASTER database have a look at : http://technet.microsoft.com/en-us/library/ms179254.asp  (which is a link from the above)

Author

Commented:
hi mark_wills:
Thanks for your reply but the last two link not work
http://technet.microsoft.com/en-us/library/ms175835.asp
 http://technet.microsoft.com/en-us/library/ms179254.asp  
thanks

Topic Advisor, Page Editor
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Mark WillsTopic Advisor, Page Editor
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
there is also a good article on Arabic language support...



SQL2k5AR.doc
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.