myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

How can i change mydatabase's collation? Options · View
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


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.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.