CODE EXAMPLE FOR SQL

mysql does collate nopad recognize space

NO PAD collations treat trailing spaces as significant in comparisons, like any other character.