KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I can't figure out which is the query to run in order to see the current collation set for a mysql database. I know I can change it running a query like this: ALTER DATABASE db_name [[DEFAULT] CHARACTER SET charset_name] [[DEFAULT] COLLATE collation_name] but I don't want to do it without knowing the current value. I think it's actually possible because in phpmyadmin you can see the current value in the operation tab of your database, but I need to do it via the command line client and after googling a little bit I found no answers. Probably I will open phpmyadmin code to discover it.. before doing it, does anybody know which is the right query? Thanks in advance.
Tags (comma-separated)
Save Edits
Cancel