 
MariaDB LENGTHB SQL Function - Length of string in bytes |
|
| | LENGTHB | Syntax: | LENGTHB(String) | | Return value: | INTEGER | | Synonyms: | OCTET_LENGTH, LENGTH | | Function type: | String function | |
| | The LENGTHB() function returns the length of "String" in required bytes.
If the "String" contains characters with more than one byte, the return value increases accordingly.
To get the length of a "String" in number of characters the function CHAR_LENGTH() should be used.
Numeric arguments are converted to strings.
If the value of the argument is NULL, the LENGTHB() function returns NULL.
Introduced in MariaDB from version 10.3.1 as part of Oracle compatibility.
If the database is not in Oracle mode, this function is equivalent to the LENGTH() function.
This feature is not present in MySQL 8.0. | SQL Examples for the LENGTHB function |
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
| SELECT CHARSET('äöü');
SELECT lengthb('test');
SELECT lengthb('äöü');
SELECT lengthb(convert('äöü' using utf8));
SELECT length(convert('äöü' USING utf8));
SELECT lengthb(convert('äöü' using utf32));
SELECT length(convert('äöü' USING utf32));
SELECT lengthb(1.3456);
SELECT lengthb(20);
SELECT lengthb(true);
SELECT lengthb(false);
SELECT lengthb(null);
|
|
| CHARSET('äöü') |
|---|
| varchar(64) BINARY |
|---|
| binary |
|
|
| lengthb('test') |
|---|
| int(10) |
|---|
| 4 |
|
| |
|
| lengthb(convert('äöü' using utf8)) |
|---|
| int(10) |
|---|
| 6 |
|
|
| length(convert('äöü' USING utf8)) |
|---|
| int(10) |
|---|
| 6 |
|
|
| lengthb(convert('äöü' using utf32)) |
|---|
| int(10) |
|---|
| 20 |
|
|
| length(convert('äöü' USING utf32)) |
|---|
| int(10) |
|---|
| 20 |
|
|
| lengthb(1.3456) |
|---|
| int(10) |
|---|
| 6 |
|
| |
| |
| |
|
| lengthb(null) |
|---|
| int(10) |
|---|
| NULL |
|
|
| | The examples were created with the MyWAY SQL manager: | How to use the LENGTHB() function in MariaDB databases | | In MariaDB, the LENGTHB() function is part of Oracle Compatibility and is used to return the length of a string in bytes. The function counts the number of bytes required to store the string. LENGTHB() in MariaDB is useful when specifically the length of a string in bytes needs to be determined and can be used for various purposes, e.g Calculating the memory requirements of character strings, analyzing data sizes or performing byte-level operations. | | Further MySQL und MariaDB SQL String functions | | CHAR | CHAR(Character code, [, Charset]) | | More about CHAR Function |
| | 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 |
| | 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 LENGTHB SQL function: |
|
|
|
|
