oh and

if the column is char(10)

and there's this data 'abc '


so is there a difference between these two ?

select * from t1 where col = 'abc'

or

select * from t1 where col='abc '