PrecisionSQLHow to Fix Collation Issues That Break Logins
Case-insensitive collations can match the wrong user.
YouTube
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?! #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
N-gated Hacker NewsAh, yes, the "thrilling" saga of YAML booleans—because regex and case sensitivity are the plot twists nobody asked for! 😴💤 Apparently, the real problem in Norway is the existential crisis of 'true' and 'false' being too ambiguous. 🤔💡
https://www.bram.us/2022/01/11/yaml-the-norway-problem/ #YAMLBooleans #RegexHumor #CaseSensitivity #NorwayTech #ExistentialCrisis #HackerNews #ngated
https://www.bram.us/2022/01/11/yaml-the-norway-problem/ #YAMLBooleans #RegexHumor #CaseSensitivity #NorwayTech #ExistentialCrisis #HackerNews #ngated
YAML: The Norway Problem
Earlier this week, Haroen Viaene posted this tweet about YAML: worst part of yaml: https://yaml.org/type/bool.html — Haroen Viaene (@haroenv) January 10, 2022 The linked-to page contains the documentation on what defines a boolean in YAML, and details that it can be parsed using this regex: y|Y|yes|Yes|YES|n|N|no|No|NO |true|True|TRUE|false|False|FALSE |on|On|ON|off|Off|OFF The reason to why this is problematic … Continue reading "YAML: The Norway Problem"
Aral BalkanNote: if you want to avoid above-mentioned case sensitivity issues with the rest of your team on Node.js projects if you’re on macOS (the extension quirk appears to be a Node quirk), add this to your jsconfig.json (or TypeScript configuration file if, for some reason, you love having a build process):
{
"compilerOptions": {
…
"forceConsistentCasingInFileNames": true,
…
}
…
}
More: https://www.typescriptlang.org/tsconfig/#forceConsistentCasingInFileNames
Protip: On Linux, if you rename a file, changing only the case of the file name somehow, e.g.,
main.layout.js → Main.layout.js,
Git will pick up the change immediately.
On macOS, because it Just Works™ and you’re holding it wrong, you have to manually tell it:
git mv main.layout.js Main.layout.js
🤷♂️
Daniel BöhmerFor reasons I am looking up if the "local part" of #email addresses is case-sensitive, i.e. if it could ever make a difference to write at [email protected] or [email protected].
Google suggested this page and I thought the professionals at #Mailchimp might be a good source. But the article is not quite correct and this simple image sooo wrong! 🤮
https://mailchimp.com/en/resources/are-email-addresses-case-sensitive/
They managed to mislabel 3 of 4 parts! 🤦♂️
Kevin Karhan 
@bebatjof @inherentlee that's a good question.
According to @Tusky, suggestions are based off one's instance, so I'm not shure if it's @Mastodon not keeping #CaseSensitivity of #Hashtags or not.
It would certainly help #accessibility if #CamelCase was the default & suggestion!
JessamynLearned an interesting thing about Mastodon filter names today. #CaseSensitivity (sorry @whknott I want to follow you but not all the writing prompt stuff and this works out well)
brianna of muffinIf I went back in time and told my younger self that Microsoft would someday make a better Windows terminal and it would be open source... I would not have believed it! 🤯 I’m excited to try it out. #microsoft #windows
Worth noting that the GitHub repo is microsoft/Terminal... not Microsoft/terminal 😉 #casesensitivity