What is the character set and collation of that MySQL Database

It does not happen often, but every once in a while you are helping someone debug his code. You run across his Database and need to double check NOW how he created that thing. To get this information you need to check: USE db_name; SELECT @@character_set_databse, @@collation_database; Alternatively, to display the values without changing the … Weiterlesen