#stringcomparison — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #stringcomparison, 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
-
String Collation Changes Comparison?!
Collation CHANGES string comparison! Case-insensitive collation makes 'A' = 'a'. This hidden setting will break your WHERE clauses!
#sql #sqltricks #collation #stringcomparison #casesensitivity #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
String Collation Changes Comparison?!
Collation CHANGES string comparison! Case-insensitive collation makes 'A' = 'a'. This hidden setting will break your WHERE clauses!
#sql #sqltricks #collation #stringcomparison #casesensitivity #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
String Collation Changes Comparison?!
Collation CHANGES string comparison! Case-insensitive collation makes 'A' = 'a'. This hidden setting will break your WHERE clauses!
#sql #sqltricks #collation #stringcomparison #casesensitivity #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
String Collation Changes Comparison?!
Collation CHANGES string comparison! Case-insensitive collation makes 'A' = 'a'. This hidden setting will break your WHERE clauses!
#sql #sqltricks #collation #stringcomparison #casesensitivity #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
String Collation Changes Comparison?!
Collation CHANGES string comparison! Case-insensitive collation makes 'A' = 'a'. This hidden setting will break your WHERE clauses!
#sql #sqltricks #collation #stringcomparison #casesensitivity #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
Empty String '' vs NULL Are DIFFERENT?!
SQL treats empty strings and NULL completely differently! This hidden difference breaks string logic. Your mind will short-circuit! Watch!
#sql #sqltricks #database #sqltutorial #emptystring #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #stringcomparison #sqlwtf
-
'Hello' = 'HELLO' Is TRUE Or FALSE?!
SQL string comparison case sensitivity depends on collation! Same strings can be equal or not. This breaks string matching! Watch!
#sql #sqltricks #database #sqltutorial #stringcomparison #casesensitivity #sqlquiz #codingchallenge #sqlshorts #sqlbugs #collation #sqlwtf
-
Empty String '' vs NULL Are DIFFERENT?!
SQL treats empty strings and NULL completely differently! This hidden difference breaks string logic. Your mind will short-circuit! Watch!
#sql #sqltricks #database #sqltutorial #emptystring #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #stringcomparison #sqlwtf
-
Empty String '' vs NULL Are DIFFERENT?!
SQL treats empty strings and NULL completely differently! This hidden difference breaks string logic. Your mind will short-circuit! Watch!
#sql #sqltricks #database #sqltutorial #emptystring #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #stringcomparison #sqlwtf
-
Empty String '' vs NULL Are DIFFERENT?!
SQL treats empty strings and NULL completely differently! This hidden difference breaks string logic. Your mind will short-circuit! Watch!
#sql #sqltricks #database #sqltutorial #emptystring #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #stringcomparison #sqlwtf
-
Empty String '' vs NULL Are DIFFERENT?!
SQL treats empty strings and NULL completely differently! This hidden difference breaks string logic. Your mind will short-circuit! Watch!
#sql #sqltricks #database #sqltutorial #emptystring #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #stringcomparison #sqlwtf
-
'Hello' = 'HELLO' Is TRUE Or FALSE?!
SQL string comparison case sensitivity depends on collation! Same strings can be equal or not. This breaks string matching! Watch!
#sql #sqltricks #database #sqltutorial #stringcomparison #casesensitivity #sqlquiz #codingchallenge #sqlshorts #sqlbugs #collation #sqlwtf
-
'Hello' = 'HELLO' Is TRUE Or FALSE?!
SQL string comparison case sensitivity depends on collation! Same strings can be equal or not. This breaks string matching! Watch!
#sql #sqltricks #database #sqltutorial #stringcomparison #casesensitivity #sqlquiz #codingchallenge #sqlshorts #sqlbugs #collation #sqlwtf
-
'Hello' = 'HELLO' Is TRUE Or FALSE?!
SQL string comparison case sensitivity depends on collation! Same strings can be equal or not. This breaks string matching! Watch!
#sql #sqltricks #database #sqltutorial #stringcomparison #casesensitivity #sqlquiz #codingchallenge #sqlshorts #sqlbugs #collation #sqlwtf
-
'Hello' = 'HELLO' Is TRUE Or FALSE?!
SQL string comparison case sensitivity depends on collation! Same strings can be equal or not. This breaks string matching! Watch!
#sql #sqltricks #database #sqltutorial #stringcomparison #casesensitivity #sqlquiz #codingchallenge #sqlshorts #sqlbugs #collation #sqlwtf
-
"10" > "2" Is FALSE?!
JavaScript string comparison is backwards! Comparing "10" and "2" gives the WRONG answer. This breaks sorting! Watch this!
#javascript #javascripttricks #codingtips #programmingtutorial #stringcomparison #javascriptquiz #codingchallenge #javascriptshorts #javascriptbugs #lexicographic #javascriptwtf #comparisonbug
-
"10" > "2" Is FALSE?!
JavaScript string comparison is backwards! Comparing "10" and "2" gives the WRONG answer. This breaks sorting! Watch this!
#javascript #javascripttricks #codingtips #programmingtutorial #stringcomparison #javascriptquiz #codingchallenge #javascriptshorts #javascriptbugs #lexicographic #javascriptwtf #comparisonbug
-
"10" > "2" Is FALSE?!
JavaScript string comparison is backwards! Comparing "10" and "2" gives the WRONG answer. This breaks sorting! Watch this!
#javascript #javascripttricks #codingtips #programmingtutorial #stringcomparison #javascriptquiz #codingchallenge #javascriptshorts #javascriptbugs #lexicographic #javascriptwtf #comparisonbug
-
"10" > "2" Is FALSE?!
JavaScript string comparison is backwards! Comparing "10" and "2" gives the WRONG answer. This breaks sorting! Watch this!
#javascript #javascripttricks #codingtips #programmingtutorial #stringcomparison #javascriptquiz #codingchallenge #javascriptshorts #javascriptbugs #lexicographic #javascriptwtf #comparisonbug
-
"10" > "2" Is FALSE?!
JavaScript string comparison is backwards! Comparing "10" and "2" gives the WRONG answer. This breaks sorting! Watch this!
#javascript #javascripttricks #codingtips #programmingtutorial #stringcomparison #javascriptquiz #codingchallenge #javascriptshorts #javascriptbugs #lexicographic #javascriptwtf #comparisonbug
-
Dasselbe, nur in Silikon (*g*) gegossen:
#Pf474 #ProximityTechnology #StringComparison #ElectronicsMagazine #ByteMagazine #Anno1983 #Anno1984