Which of the following methods can be used to find out which character sets are in use across the server?

Which of the following methods can be used to find out which character sets are in use across the server?

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 |
+——————–+



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Google

Google

Below youll uncover the link to some web pages that we believe you must visit.