The CHAR SQL Function in MySQL and MariaDB - String of character codes |
|
| | CHAR | Syntax: | CHAR(Charcode [, Charcode ...] [USING Charset]) | | Return value: | CHAR | | Function type: | String function | |
| | The CHAR() function returns a character string of characters made up of the code values of one or more "Charcode" arguments.
By default, CHAR() returns a binary string, but the character set can be specified using the USING clause.
Floating point values are rounded to integer numbers.
Strings are interpreted as numbers, returning CHAR(0) for invalid values.
NULL values in the arguments are skipped. | SQL Examples for the CHAR function |
1
2
3
4
5
6
7
8
9
10
11
12
13
|
| select char(65);
select char(65,66,67);
select char(0x65,0x66,0x67);
select charset(char(65,66,67));
select charset(char(65,66,67 using utf8mb4));
select char(65,65.4,65.6);
select hex(char('65','65x','0x65','xx','1.5'));
select char(65,null,null,66,null,67);
select char(null);
|
|
| char(65) |
|---|
| varchar(4) BINARY |
|---|
| A |
|
|
| char(65,66,67) |
|---|
| varchar(12) BINARY |
|---|
| ABC |
|
|
| char(0x65,0x66,0x67) |
|---|
| varchar(12) BINARY |
|---|
| efg |
|
|
| charset(char(65,66,67)) |
|---|
| varchar(64) BINARY |
|---|
| binary |
|
|
| charset(char(65,66,67 using utf8mb4)) |
|---|
| varchar(64) BINARY |
|---|
| utf8mb4 |
|
|
| char(65,65.4,65.6) |
|---|
| varchar(12) BINARY |
|---|
| AAB |
|
|
| hex(char('65','65x','0x65','xx','1.5')) |
|---|
| varchar(40) BINARY |
|---|
| 4141000001 |
|
|
| char(65,null,null,66,null,67) |
|---|
| varchar(24) BINARY |
|---|
| ABC |
|
|
| char(null) |
|---|
| varchar(4) BINARY |
|---|
| |
|
|
| | The examples were created with the MyWAY SQL manager: | How to use the CHAR() function in MySQL and MariaDB databases | | The CHAR() function in MySQL and MariaDB is used to get a numeric value based on the Convert ASCII code to the corresponding character. The function takes one or more numeric arguments, representing ASCII codes, and returns a string consisting of the appropriate characters. The function can be used, for example, when generating strings based on ASCII codes, when manipulating character data, or when performing custom string conversions in certain applications. | | Further MySQL und MariaDB SQL String functions | | CHR | CHR(Character code) | | More about CHR Function |
| | CONCAT | CONCAT(Strings ('str1','str2', ...)) | | More about CONCAT Function |
| | CONCAT_WS | CONCAT_WS(Separator, Strings ('str1','str2', ...)) | | More about CONCAT_WS Function |
| | ELT | ELT(Index, Strings ('str1','str2', ...)) | | More about ELT Function |
| | EXPORT_SET | EXPORT_SET(Bits, On, Off [, Separator] [, Number of bits]) | | More about EXPORT_SET Function |
| | EXTRACTVALUE | EXTRACTVALUE(XML, XPath) |
| | FIELD | FIELD(Search string, Strings ('str1','str2', ...)) | | More about FIELD Function |
| | FORMAT | FORMAT(Number, Decimals [, Region]) | | More about FORMAT Function |
| | INSERT | INSERT(String, Position, Length, String to insert) | | More about INSERT Function |
| | LCASE | LCASE(String) | | More about LCASE Function |
| | LEFT | LEFT(String, Length) | | More about LEFT Function |
| | LOAD_FILE | LOAD_FILE(File name) |
| | LOWER | LOWER(String) | | More about LOWER Function |
| | LPAD | LPAD(String, Length, String to append) | | More about LPAD Function |
| | LPAD_ORACLE | LPAD_ORACLE(String, Length, String to append) | | More about LPAD_ORACLE Function |
| | LTRIM | LTRIM(String) | | More about LTRIM Function |
| | MAKE_SET | MAKE_SET(Bits, Strings ('str1','str2', ...)) | | More about MAKE_SET Function |
| | MID | MID(String, Position [, Length]) | | More about MID Function |
| | QUOTE | QUOTE(String) | | More about QUOTE Function |
| | REPEAT | REPEAT(String, Number) | | More about REPEAT Function |
| | REPLACE | REPLACE(String, Search, Replace) | | More about REPLACE Function |
| | REVERSE | REVERSE(String) | | More about REVERSE Function |
| | RIGHT | RIGHT(String, Length) | | More about RIGHT Function |
| | RPAD | RPAD(String, Length, String to append) | | More about RPAD Function |
| | RPAD_ORACLE | RPAD_ORACLE(String, Length, String to append) | | More about RPAD_ORACLE Function |
| | RTRIM | RTRIM(String) | | More about RTRIM Function |
| | SOUNDEX | SOUNDEX(String) | | More about SOUNDEX Function |
| | SPACE | SPACE(Number) | | More about SPACE Function |
| | SUBSTR | SUBSTR(String, Position, Length) | | More about SUBSTR Function |
| | SUBSTRING | SUBSTRING(String, Position, Length) | | More about SUBSTRING Function |
| | SUBSTRING_INDEX | SUBSTRING_INDEX(String, Delimiter, Number) | | More about SUBSTRING_INDEX Function |
| | TRIM | TRIM([Type] [, Delete character], , String) | | More about TRIM Function |
| | TRIM_ORACLE | TRIM_ORACLE([Type] [, Delete character], , String) | | More about TRIM_ORACLE Function |
| | UCASE | UCASE(String) | | More about UCASE Function |
| | UPPER | UPPER(String) | | More about UPPER Function |
| | WEIGHT_STRING | WEIGHT_STRING(String [AS Format] [LEVEL Level] [Sorting]) | | More about WEIGHT_STRING Function |
| | ASCII | ASCII(String) | | More about ASCII Function |
| | BIT_LENGTH | BIT_LENGTH(String) | | More about BIT_LENGTH Function |
| | CHAR_LENGTH | CHAR_LENGTH(String) | | More about CHAR_LENGTH Function |
| | CHARACTER_LENGTH | CHARACTER_LENGTH(String) | | More about CHARACTER_LENGTH Function |
| | FIND_IN_SET | FIND_IN_SET(Search string, Set of values) | | More about FIND_IN_SET Function |
| | INSTR | INSTR(String, Search string) | | More about INSTR Function |
| | LENGTH | LENGTH(String) | | More about LENGTH Function |
| | LENGTHB | LENGTHB(String) | | More about LENGTHB Function |
| | LOCATE | LOCATE(Search string, String [, Position]) | | More about LOCATE Function |
| | OCTET_LENGTH | OCTET_LENGTH(String) | | More about OCTET_LENGTH Function |
| | ORD | ORD(String) | | More about ORD Function |
| | POSITION | POSITION(Search string IN String) | | More about POSITION Function |
|
|
| | | More information about the CHAR SQL function: and |
|
|
|
|
