I know I must be missing something pretty obvious, but what setting
should I change to get the correct length of my string ie why does the
select statement below return 1 when it looks fairly obvious that the
second string is a tad longer than 1

select len('a ')
select len('a ')