Does Mysql omit trailing whitespaces?

Asked Nov 09 '21 at 15:48

Active Nov 09 '21 at 16:25

Viewed 16 times

Does anyone know what is the reason of my mysql giving the same results for:

select * from table where column = "xyz"

and

select * from table where column = "xyz "

(but

select * from table where column = " xyz"

not equals to

select * from table where column = "xyz";

Thanks!

edited Nov 09 '21 at 16:25

Barmar

asked Nov 09 '21 at 15:48

v-peter

Does https://stackoverflow.com/questions/16724574/mysql-select-fields-containing-leading-or-trailing-whitespace/16724624 help? – Nico Haase Nov 09 '21 at 15:55
Or this? https://stackoverflow.com/questions/39572183/comparison-with-trailing-spaces-in-mysql – Nico Haase Nov 09 '21 at 15:56
Thanks, nice, so I have to use LIKE instead of =. – v-peter Nov 09 '21 at 16:02

0 Answers0