MySQL Tutorial/Information Functions/CHARSET

CHARSET(str): Returns the character set of the string argument.

   <source lang="sql">

mysql> mysql> SELECT CHARSET("abc"); +----------------+ | CHARSET("abc") | +----------------+ | latin1 | +----------------+ 1 row in set (0.00 sec) mysql></source>

SELECT CHARSET(CONVERT("abc" USING utf8));

   <source lang="sql">

mysql> mysql> SELECT CHARSET(CONVERT("abc" USING utf8)); +------------------------------------+ | CHARSET(CONVERT("abc" USING utf8)) | +------------------------------------+ | utf8 | +------------------------------------+ 1 row in set (0.00 sec) mysql></source>

SELECT CHARSET(USER());

   <source lang="sql">

mysql> mysql> SELECT CHARSET(USER()); +-----------------+ | CHARSET(USER()) | +-----------------+ | utf8 | +-----------------+ 1 row in set (0.00 sec) mysql></source>