CHAR vs VARCHAR Comparison Returns ZERO Rows?!

STRING COMPARISON IS BROKEN! CHAR pads with spaces, VARCHAR doesn't! 'test' does NOT equal 'test '! Your WHERE clause returns ZERO rows! This breaks string matching! Watch!

#sql #sqlbug #char #varchar #trailingspaces #comparisonfails #sqlfails #productionbug #sqlshorts #sqlwtf #stringcomparison #padding

https://www.youtube.com/watch?v=aE5TuRmO_PQ

CHAR vs VARCHAR Padding?!

CHAR PADS with spaces! VARCHAR doesn't. LENGTH() returns different values for same string in CHAR vs VARCHAR. This padding will break comparisons!

#sql #sqltricks #char #varchar #padding #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringtypes #advancedsql

https://www.youtube.com/watch?v=0DNOIV-lXyo

Technical people of the Interwebs, I have a question

If I were to create a table in a MySQL database with a field called emoji of type VarChar, what size would it need to hold a single emoji from all available (and future) emoji characters? I’m using utf8mb4 encoding.

#emoji #MySQL #utf8mb4 #VarChar