Which of the following methods can be used to find out which character sets are in use across the server?
A.
SHOW CHARACTER SETS
B.
Use the INFORMATION_SCHEMA.COLUMNS table
C.
This can not be done
Explanation:
SHOW CHARACTER SET; (singular) lists all character sets available for all of the databases on the server.
— SELECT DISTINCT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLUMNS;
+——————–+
| CHARACTER_SET_NAME |
+——————–+
| utf8 |
| NULL |
| latin1 |
+——————–+
Below youll uncover the link to some web pages that we believe you must visit.