The BYTE_LENGTH function returns the number of bytes in a string.
The BYTE_LENGTH function supports both LONG BINARY columns and variables and LONG VARCHAR columns and variables, only if the query returns less than 2GB. If the byte length of the returned LONG BINARY or LONG VARCHAR data is greater than or equal to 2GB, BYTE_LENGTH returns an error that says you must use the BYTE_LENGTH64 function.
For BYTE_LENGTH function syntax and usage, see “BYTE_LENGTH function [String]” in Chapter 4, “SQL Functions” in Reference: Building Blocks, Tables, and Procedures.
