totn MariaDB Functions

MariaDB: LENGTH Function

This MariaDB tutorial explains how to use the MariaDB LENGTH function with syntax and examples.

Description

The MariaDB LENGTH function returns the length of the specified string (measured in bytes).

Syntax

The syntax for the LENGTH function in MariaDB is:

LENGTH( string )

Parameters or Arguments

string
The string to return the length for.

Note

  • When using the LENGTH function, a multi-byte character is counted as more than one byte.
  • See also the CHAR_LENGTH function.

Applies To

The LENGTH function can be used in the following versions of MariaDB:

  • MariaDB 10

Example

Let's look at some MariaDB LENGTH function examples and explore how to use the LENGTH function in MariaDB.

For example:

SELECT LENGTH('Tech on the Net');
Result: 15

SELECT LENGTH('TechOnTheNet.com');
Result: 16

SELECT LENGTH(' ');
Result: 1

SELECT LENGTH('');
Result: 0

SELECT LENGTH(NULL);
Result: NULL
Share on: