Which function returns the number of characters in a string?

Which function returns the number of characters in a string?

• A. CharLength
• B. StringLength
• C. ByteLength
• D. Length

Answer: (D)

Counting characters means asking for how many individual characters appear in the string, not how much space it takes up in memory. Length is the function commonly used to return that character count in many SQL dialects, giving you the number of characters regardless of how many bytes are used to store them. ByteLength, by contrast, reports the storage size in bytes, which can differ when multibyte characters are involved. CharLength or CharacterLength exist in some systems as names for the same idea, but in this context Length is the standard choice for getting the character count.

Counting characters means asking for how many individual characters appear in the string, not how much space it takes up in memory. Length is the function commonly used to return that character count in many SQL dialects, giving you the number of characters regardless of how many bytes are used to store them. ByteLength, by contrast, reports the storage size in bytes, which can differ when multibyte characters are involved. CharLength or CharacterLength exist in some systems as names for the same idea, but in this context Length is the standard choice for getting the character count.