Select trims spaces from strings - is this a bug or in the spec?

Question

in mysql:

select 'a' = 'a     ';

return 1

Answer 1

You're not the first to find this frustrating. In this case, use LIKE for literal string comparison:

SELECT 'a' LIKE 'a    ';    //returns 0