UPPER(str)

MySQL 8.4

Returns the string str with all characters changed to uppercase according to the current character set mapping, or NULL if str is NULL. The default character set is utf8mb4.

Syntax

MYSQL

SELECT UPPER('Hej');
'HEJ'

Examples

Example

See the description of LOWER() for information that also applies to UPPER(). This included information about how to perform lettercase conversion of binary strings (BINARY, VARBINARY, BLOB) for which these functions are ineffective, and information about case folding for Unicode character sets.

MYSQL

SELECT UPPER('Hej');
'HEJ'