LEN('') vs LEN(NULL) vs LEN(' ') Are DIFFERENT?!
LEN of empty string, NULL, and space are all different! Empty = 0, NULL = NULL, Space = 1. This breaks string length logic! Watch!
#sql #sqltricks #database #sqltutorial #len #stringlength #sqlquiz #codingchallenge #sqlshorts #sqlbugs #stringfunctions #sqlwtf
It's Not Wrong that " ".length == 7
https://hsivonen.fi/string-length/
#HackerNews #StringLength #HackerNews #Coding #Standards #Programming #Insights #TechDiscussion
This library is a C# source generator designed to automatically generate string length constants from Entity Framework configurations and data annotations.
PrecisionSQL
Hacker News
Taras Kovalenko