CHARSET
On this page
Takes a string argument and returns the character set of that argument.
Syntax
CHARSET(string)
Arguments
-
String
Return Type
-
Character set
Examples
SELECT CHARSET(char(189));
+--------------------+
| CHARSET(char(189)) |
+--------------------+
| binary |
+--------------------+
1 row in set (0.06 sec)SELECT CHARSET(char(189 using utf8));
+-------------------------------+
| CHARSET(char(189 using utf8)) |
+-------------------------------+
| utf8 |
+-------------------------------+
1 row in set (0.06 sec)Related Topics
Caution
Implicit Collation
When character_ is set to utf8, string literals with characters using 4-byte encoding are implicitly assigned binary collation and processed as a sequence of bytes rather than characters.utf8mb4 character set.
For more information, refer to Implicit Collation in Special Cases.
Last modified: February 27, 2023