• This one got me. I selected 5,5,5 because I'm used to having padding spaces with the CHAR datatype. That's why I use Varchar instead when the contents of the column doesn't contain a consistent number of characters.

    if you were to select them without the LEN function, you would get

    abcde ab... ab...

    (the period was used to make spaces visible).