ID EN
Information Functions

CHARSET(str)

MySQL 8.4

Returns the character set of the string argument, or NULL if the argument is NULL.

Syntax

MYSQL
SELECT CHARSET('abc');
'utf8mb3'
SELECT CHARSET(CONVERT('abc' USING latin1));
'latin1'
SELECT CHARSET(USER());
'utf8mb3'

Examples

Example
MYSQL
SELECT CHARSET('abc');
'utf8mb3'
SELECT CHARSET(CONVERT('abc' USING latin1));
'latin1'
SELECT CHARSET(USER());
'utf8mb3'