v.23.7New Feature

Add OCTET_LENGTH Alias for length

Official CH changelog text
Add OCTET_LENGTH as an alias to length. Closes #52153. #52176 (FFFFFFFHHHHHHH).
OCTET_LENGTH function added as an alias to length.

Why it matters

Provides users with a familiar SQL function name OCTET_LENGTH that returns the length of a string in bytes, improving compatibility and usability for those migrating from or accustomed to other SQL systems.

How to use it

Simply use the OCTET_LENGTH function in your SQL queries as you would use length, for example:

SELECT OCTET_LENGTH(column_name) FROM table_name;

Related resources

PreviousNext