What’s the difference between CHAR_LENGTH and LE
More DBA job interview questions and answers at
What’s the difference between CHAR_LENGTH and LENGTH?
The first is, naturally, the character count. The second is byte count. For the Latin characters the numbers are the same, but they’re not the same for Unicode and other encodings.
Other Job Interview Questions