How do I view the default collation (character set) of my database?

Login to Plesk
Home -> Databases -> (click on) the Icon at the end of the line of the DB you want to view (you may have to scroll over)
This will launch ASP Enterprise manager
(click on) The Icon with the Magnifing glass over a computer (should be in the middle by itself)
This will bring up a query window.
Put in the following: SELECT DATABASEPROPERTYEX('my_database' , 'collation');
(replace my_database with your database name)
Select "run query"
It will print out below that box which character set you are using.

If you want to change what character set you are using you will need to open a ticket to have us do it for you.
Please include in the ticket:
Which server you are on (it says in list accounts, in RC, next to the site)
The name of the database you want the character set changed on*
What character set you want the database changed to (there is a list here: http://msdn.microsoft.com/en-us/library/ms143508.aspx )

*: NOTE, the database name _CANNOT_ have an - in it, the way to change the collation will just error out if the DB has a - in it, so only use _'s, letters, and numbers in your DB names.

  • 110 istifadəçi bunu faydalı hesab edir
Bu cavab sizə kömək etdi?