> real length in characters = 4/4 = 1
> truncate the result to 1 character to get 'Y'

Why not simply declare the column in database with CHARACTER SET NONE
if you keep only 'Y' and 'N' there?.. In this case it will be one-byte
on client.

SY, SD.