LENGTHC

LENGTHC is a SQL function used in Oracle PL/SQL programming. This function returns the length of the specified string but unlike LENGTH, LENGTHC counts characters and not bytes. It is especially important in a multibyte character set where a single character may consist of up to four bytes.

Example

SELECT LENGTHC('Hello, World') FROM dual;

Output

12

Explanation

The LENGTHC function in the given SQL code returns the size of the string ‘Hello, World’. The size here, 12, is the number of characters in the string. This includes all alphabets, numbers, special characters, and spaces. The LENGTHC function in Oracle can be used to retrieve the length of a string in this way.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.