How can i change mydatabase's collation? - Web-Hosting

Welcome Guest

Search | Active Topics | Members | Log In | Register

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Web-Hosting » How can i change mydatabase's collation?

How can i change mydatabase's collation?

Options · View

Previous Topic · Next Topic

enginyvz

Posted: Monday, April 21, 2008 3:39:22 PM

Rank: Newbie
Groups: Member

Joined: 4/21/2008
Posts: 2
Points: 0

i want to change my collation as 'Turkish CI_AS', but how?

elian

Posted: Tuesday, April 22, 2008 10:08:39 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France

Run the following query

Code:

ALTER DATABASE yourDbName COLLATE 'Turkish_CI_AS'

Note that it requires you have ALTER permission on the database.

enginyvz

Posted: Monday, April 28, 2008 4:41:33 PM

Rank: Newbie
Groups: Member

Joined: 4/21/2008
Posts: 2
Points: 0

Thank you..

pbms

Posted: Friday, May 22, 2009 11:12:26 PM

Rank: Newbie
Groups: Member

Joined: 5/22/2009
Posts: 1
Points: 3

I encountered the same problem, Could you please tell me the location I run the query in myLittleTools?

Users browsing this topic

Guest

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Web-Hosting » How can i change mydatabase's collation?

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.