#varchar — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #varchar, aggregated by home.social.
-
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
-
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
-
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
-
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
-
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.