Determine what a MySQL DB’s charset is set to

Let’s say we are creating a database “web” −

mysql> SHOW CREATE DATABASE web;

This will produce the following output displaying the default charset as well −

+----------+-----------------------------------------------------------------------------------------+
| Database | Create Database                                                                         |
+----------+-----------------------------------------------------------------------------------------+
| web      | CREATE DATABASE `web` /*!40100 DEFAULT CHARACTER SET utf8 COLLATEutf8_unicode_ci */     | 
+----------+-----------------------------------------------------------------------------------------+
1 row in set (0.03 sec)

If you want to know the charset for a particular table from a databse, then use the below query. Here, let’s say we have a table with name DemoTable in the database “web” −

mysql> SHOW CREATE table web.DemoTable;

This will produce the following output displaying the charset −

+--------------+----------------------------------------------------------------------------------------------------------------------------------+
| Table        | Create Table                                                                                                                     |
+--------------+----------------------------------------------------------------------------------------------------------------------------------+
| DemoTable    | CREATE TABLE `DemoTable` (`Value` int(11) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci               |
+--------------+----------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Karthikeya Boyini

Published on 09-Jul-2019 13:50:46

• Related Questions & Answers
• Set column charset in MySQL?
• What is Bitcoin’s Lightning Network?
• What is the meaning of ‘empty set’ in MySQL result set?
• What is Kleene’s Theorem in TOC?
• What is some lunch box Do’s and Dont’s for an underweight child?
• Write MySQL case statement to set custom messages for student’s result
• What is Flynn’s Taxonomy in Computer Architecture?
• What is Power Spectral Density & it’s benefits?
• C++ Program to Implement Dijkstra’s Algorithm Using Set
• Store a column's value into a MySQL stored procedure’s variable
• How to change the default charset of a MySQL table?
• Find yesterday’s, today’s and tomorrow’s date in Python
• 1’s and 2’s complement of a Binary Number?
• What is this problem in JavaScript’s selfexecuting anonymous function?
• Design a TM for equal number of a’s and b’s