#STRLEN MYSQL CODE#

The following example uses the LENGTH() to get the length of the string Café in latin1 and utf8mb3 character sets: SELECT LENGTH( 'Café') length_latin1,Ĭode language: SQL (Structured Query Language) ( sql )ġ row in set, 1 warning (0.00 sec) Code language: JavaScript ( javascript )

The query returns 5 because the string 'Hello' contains five characters and each character is represented using a single byte in the latin1 character set. The following example uses the LENGTH() function to return the length of a string in the Latin1 character set: SELECT LENGTH( 'Hello') as length Code language: JavaScript ( javascript ) Let’s take some examples of using the LENGTH() function.

To find the character set that the current database uses, you use the variable: SELECT Code language: CSS ( css )ġ row in set (0.00 sec) Code language: JavaScript ( javascript )įor the rest of the tutorial, we assume that you use the latin1 as the default character set. In the output, the Maxlen column shows the maximum number of bytes for each character. | binary | Binary pseudo charset | binary | 1 | | big5 | Big5 Traditional Chinese | big5_chinese_ci | 2 | | ascii | US ASCII | ascii_general_ci | 1 | | armscii8 | ARMSCII -8 Armenian | armscii8_general_ci | 1 | | Charset | Description | Default collation | Maxlen | To find available character sets in the current database, you use the following statement: SHOW CHARACTER SET In such cases, the length of a string in character may be different from its length in bytes. In multi-byte character sets, such as UTF-8, MySQL represents characters using multiple bytes. For these character sets, the length of a string in characters is equal to its length in bytes. In a single-byte character set, MySQL represents each character using a single byte. MySQL supports various character sets, including single-byte and multi-byte character sets. Understanding character setsĬharacter sets define how MySQL store and represent characters in a database. Note that to get the number of characters of a string, you use the CHAR_LENGTH() function instead. Therefore, the result of the LENGTH() function is based on the current character set of the string. The LENGTH() function takes a string argument and returns its length measured in bytes. Here’s the basic syntax of the LENGTH() function: LENGTH(string) The LENGTH() function returns the length of a string measured in bytes. Summary: in this tutorial, you will learn about the MySQL LENGTH() function to get the length of strings in bytes.

Strlen mysql