#collation — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #collation, aggregated by home.social.
-
How to Fix Collation Issues That Break Logins
Case-insensitive collations can match the wrong user.
-
How to Fix Collation Issues That Break Logins
Case-insensitive collations can match the wrong user.
-
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
-
'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
-
@emchateau thanks for the hint to David J. Birnbaum's collection!
Funny coincidence, I am just on my way to what will surely be a wonderful and productive workshop on #Collation and #Visualisation (https://www.lorentzcenter.nl/seeing-the-difference-visualizing-textual-variation.html), and am reading (and can recommend) a #Balisage paper by said D. Birnbaum & Ronald Dekker in preparation: https://doi.org/10.4242/BalisageVol29.Birnbaum01
I will check out the #XSLT learning resources you mentioned and the ones other might still mention during the week, thanks again!
CC @petrichor
-
@emchateau thanks for the hint to David J. Birnbaum's collection!
Funny coincidence, I am just on my way to what will surely be a wonderful and productive workshop on #Collation and #Visualisation (https://www.lorentzcenter.nl/seeing-the-difference-visualizing-textual-variation.html), and am reading (and can recommend) a #Balisage paper by said D. Birnbaum & Ronald Dekker in preparation: https://doi.org/10.4242/BalisageVol29.Birnbaum01
I will check out the #XSLT learning resources you mentioned and the ones other might still mention during the week, thanks again!
CC @petrichor
-
Livro #PythonFluente do @lr é uma preciosidade incrível. O capítulo 4 "Texto em Unicode versus Bytes" então é um arraso total
https://pythonfluente.com/#strings_bytes_filesHoje eu consultei numa aula para falar sobre a questão da ordenação de strings de maneira adequada ao português... https://pythonfluente.com/#sorting_unicode_sec
-
Livro #PythonFluente do @lr é uma preciosidade incrível. O capítulo 4 "Texto em Unicode versus Bytes" então é um arraso total
https://pythonfluente.com/#strings_bytes_filesHoje eu consultei numa aula para falar sobre a questão da ordenação de strings de maneira adequada ao português... https://pythonfluente.com/#sorting_unicode_sec
-
#Collation problem identified in a project.
A good time to remind that sorting data isn't a question of yes or no. There are language specific rules to represent sorted data.
-
#Collation problem identified in a project.
A good time to remind that sorting data isn't a question of yes or no. There are language specific rules to represent sorted data.
-
Every time I fill out an online form, when I get to the State field, I imagine Tennessee saying, "Suck it, Texas. Too bad you have to do the extra click and select thing..." :-) #collation #alphabeticalorder Except having lived in both states, TN wouldn't say that. TX might if the alphabet were reversed...