Collections:
CHARSET() - Detecting Character Set Name
How to detect the character set name associated to a given character string using the CHARSET() function?
✍: FYIcenter.com
CHARSET(str) is a MySQL built-in function that returns the character set name associated to a given character string. A character set name refers to a set of rules to encode a set of characters into byte sequences. For example:
SELECT CHARSET('FYI'); -- +----------------+ -- | CHARSET('FYI') | -- +----------------+ -- | utf8 | -- +----------------+ SELECT CHARSET(CONVERT('FYI' USING latin1)); -- +--------------------------------------+ -- | CHARSET(CONVERT('FYI' USING latin1)) | -- +--------------------------------------+ -- | latin1 | -- +--------------------------------------+ CREATE TABLE MyTable (comment CHAR(80) CHARACTER SET utf8mb4); INSERT INTO MyTable (comment) VALUES ('I like it!'); INSERT INTO MyTable (comment) VALUES ('Good job1'); SELECT comment, CHARSET(comment) FROM MyTable; -- +------------+------------------+ -- | comment | CHARSET(comment) | -- +------------+------------------+ -- | I like it! | utf8mb4 | -- | Good job1 | utf8mb4 | -- +------------+------------------+
Reference information of the CHARSET() function:
CHARSET(str): name Returns the character set name associated to a given character string. Arguments, return value and availability: str: Required. The character string to be examined. name: Return value. The character set name. Available since MySQL 4.0.
Related MySQL functions:
⇒ COERCIBILITY() - Character Collation Coercibility
⇐ CHARACTER_LENGTH() - Synonym for CHAR_LENGTH()
2023-12-18, 272🔥, 0💬
Popular Posts:
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...