TechHub

zartomHow to Change Column Collation in MySQL Need to change column collation in MySQL? Our guide covers updating single columns, tables, and databases for better character support. Learn SQL commands & automation tips! <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> <a href="https://mastodon.social/tags/Collation" class="mention hashtag" rel="nofollow noopener" target="_blank">#Collation</a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#Database</a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> <a href="https://mastodon.social/tags/CharacterSet" class="mention hashtag" rel="nofollow noopener" target="_blank">#CharacterSet</a> <a href="https://mastodon.social/tags/UTF8MB4" class="mention hashtag" rel="nofollow noopener" target="_blank">#UTF8MB4</a> <a href="https://tech-champion.com/database/mysql/how-to-change-column-collation-in-mysql/" rel="nofollow noopener" translate="no" target="_blank">https://tech-champion.com/database/mysql/how-to-change-column-collation-in-mysql/</a> ...

Christian Thomas<a href="https://mamot.fr/@emchateau" class="u-url mention" rel="nofollow noopener" target="_blank">@emchateau</a> 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 <a href="https://fedihum.org/tags/Collation" class="mention hashtag" rel="nofollow noopener" target="_blank">#Collation</a> and <a href="https://fedihum.org/tags/Visualisation" class="mention hashtag" rel="nofollow noopener" target="_blank">#Visualisation</a> (<a href="https://www.lorentzcenter.nl/seeing-the-difference-visualizing-textual-variation.html" rel="nofollow noopener" translate="no" target="_blank">https://www.lorentzcenter.nl/seeing-the-difference-visualizing-textual-variation.html</a>), and am reading (and can recommend) a <a href="https://fedihum.org/tags/Balisage" class="mention hashtag" rel="nofollow noopener" target="_blank">#Balisage</a> paper by said D. Birnbaum & Ronald Dekker in preparation: <a href="https://doi.org/10.4242/BalisageVol29.Birnbaum01" rel="nofollow noopener" translate="no" target="_blank">https://doi.org/10.4242/BalisageVol29.Birnbaum01</a>I will check out the <a href="https://fedihum.org/tags/XSLT" class="mention hashtag" rel="nofollow noopener" target="_blank">#XSLT</a> learning resources you mentioned and the ones other might still mention during the week, thanks again!CC <a href="https://digipres.club/@petrichor" class="u-url mention" rel="nofollow noopener" target="_blank">@petrichor</a>

Aurianne OrVous n’en avez jamais assez… Assez !: <a href="https://www.aurianneor.org/vous-nen-avez-jamais-assez-assez/" rel="nofollow noopener" translate="no" target="_blank">https://www.aurianneor.org/vous-nen-avez-jamais-assez-assez/</a><a href="https://mastodon.social/tags/achats" class="mention hashtag" rel="nofollow noopener" target="_blank">#achats</a> <a href="https://mastodon.social/tags/argent" class="mention hashtag" rel="nofollow noopener" target="_blank">#argent</a> <a href="https://mastodon.social/tags/argentdelacommunaut%C3%A9" class="mention hashtag" rel="nofollow noopener" target="_blank">#argentdelacommunauté</a> <a href="https://mastodon.social/tags/assez" class="mention hashtag" rel="nofollow noopener" target="_blank">#assez</a> <a href="https://mastodon.social/tags/aurianneor" class="mention hashtag" rel="nofollow noopener" target="_blank">#aurianneor</a> <a href="https://mastodon.social/tags/avidit%C3%A9" class="mention hashtag" rel="nofollow noopener" target="_blank">#avidité</a> <a href="https://mastodon.social/tags/bonmarch%C3%A9" class="mention hashtag" rel="nofollow noopener" target="_blank">#bonmarché</a> <a href="https://mastodon.social/tags/collation" class="mention hashtag" rel="nofollow noopener" target="_blank">#collation</a> <a href="https://mastodon.social/tags/consommateur" class="mention hashtag" rel="nofollow noopener" target="_blank">#consommateur</a> <a href="https://mastodon.social/tags/diab%C3%A8te" class="mention hashtag" rel="nofollow noopener" target="_blank">#diabète</a> <a href="https://mastodon.social/tags/%C3%A9tatprovidence" class="mention hashtag" rel="nofollow noopener" target="_blank">#étatprovidence</a> <a href="https://mastodon.social/tags/Ican" class="mention hashtag" rel="nofollow noopener" target="_blank">#Ican</a>’tgetnosatisfaction <a href="https://mastodon.social/tags/ifIwerearichman" class="mention hashtag" rel="nofollow noopener" target="_blank">#ifIwerearichman</a> <a href="https://mastodon.social/tags/industriel" class="mention hashtag" rel="nofollow noopener" target="_blank">#industriel</a> <a href="https://mastodon.social/tags/ingr%C3%A9dients" class="mention hashtag" rel="nofollow noopener" target="_blank">#ingrédients</a> <a href="https://mastodon.social/tags/justcan" class="mention hashtag" rel="nofollow noopener" target="_blank">#justcan</a>’tgetenough <a href="https://mastodon.social/tags/manger" class="mention hashtag" rel="nofollow noopener" target="_blank">#manger</a> <a href="https://mastodon.social/tags/manufactur%C3%A9" class="mention hashtag" rel="nofollow noopener" target="_blank">#manufacturé</a> <a href="https://mastodon.social/tags/marges" class="mention hashtag" rel="nofollow noopener" target="_blank">#marges</a> <a href="https://mastodon.social/tags/marques" class="mention hashtag" rel="nofollow noopener" target="_blank">#marques</a> <a href="https://mastodon.social/tags/nourriture" class="mention hashtag" rel="nofollow noopener" target="_blank">#nourriture</a> <a href="https://mastodon.social/tags/ob%C3%A9sit%C3%A9" class="mention hashtag" rel="nofollow noopener" target="_blank">#obésité</a> <a href="https://mastodon.social/tags/oxfam" class="mention hashtag" rel="nofollow noopener" target="_blank">#oxfam</a> <a href="https://mastodon.social/tags/pascher" class="mention hashtag" rel="nofollow noopener" target="_blank">#pascher</a> <a href="https://mastodon.social/tags/platpr%C3%A9par%C3%A9" class="mention hashtag" rel="nofollow noopener" target="_blank">#platpréparé</a> <a href="https://mastodon.social/tags/pr%C3%AAt" class="mention hashtag" rel="nofollow noopener" target="_blank">#prêt</a>-à-manger <a href="https://mastodon.social/tags/prix" class="mention hashtag" rel="nofollow noopener" target="_blank">#prix</a> <a href="https://mastodon.social/tags/qualit%C3%A9" class="mention hashtag" rel="nofollow noopener" target="_blank">#qualité</a> <a href="https://mastodon.social/tags/sant%C3%A9" class="mention hashtag" rel="nofollow noopener" target="_blank">#santé</a> <a href="https://mastodon.social/tags/saveur" class="mention hashtag" rel="nofollow noopener" target="_blank">#saveur</a> <a href="https://mastodon.social/tags/snack" class="mention hashtag" rel="nofollow noopener" target="_blank">#snack</a> <a href="https://mastodon.social/tags/subventions" class="mention hashtag" rel="nofollow noopener" target="_blank">#subventions</a> <a href="https://mastodon.social/tags/ultratransform%C3%A9" class="mention hashtag" rel="nofollow noopener" target="_blank">#ultratransformé</a>

Alexandre B A Villares 🐍Livro <a href="https://ciberlandia.pt/tags/PythonFluente" class="mention hashtag" rel="nofollow noopener" target="_blank">#PythonFluente</a> do <a href="https://ciberlandia.pt/@lr" class="u-url mention" rel="nofollow noopener" target="_blank">@lr</a> é uma preciosidade incrível. O capítulo 4 "Texto em Unicode versus Bytes" então é um arraso total <a href="https://pythonfluente.com/#strings_bytes_files" rel="nofollow noopener" translate="no" target="_blank">https://pythonfluente.com/#strings_bytes_files</a>Hoje eu consultei numa aula para falar sobre a questão da ordenação de strings de maneira adequada ao português... <a href="https://pythonfluente.com/#sorting_unicode_sec" rel="nofollow noopener" translate="no" target="_blank">https://pythonfluente.com/#sorting_unicode_sec</a><a href="https://ciberlandia.pt/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#Python</a> <a href="https://ciberlandia.pt/tags/unicode" class="mention hashtag" rel="nofollow noopener" target="_blank">#unicode</a> <a href="https://ciberlandia.pt/tags/collation" class="mention hashtag" rel="nofollow noopener" target="_blank">#collation</a>

Claudio Zizza 🦜<a href="https://phpc.social/tags/Collation" class="mention hashtag" rel="nofollow noopener" target="_blank">#Collation</a> 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.

💾 Paweł ŁukasikOne of the functions that was mentioned in yesterday's post was EF.Functions.Collate, and collation is the thing that might cause issues when combining the DB and .NET code.You might set collation on the DB so that upper and lower case letters will be treated the same - no distinctions. String equality, on the other hand, does recognize lower and upper characters. So if we combine the two, we get into trouble.Let's assume that we have a simple table with a varchar column and a unique constraint on it with a collation that doesn't differentiate between lower and upper case. Now, we have the following code that loads data into memory and checks if an entry exists before adding it. Our comparison will be fruitless, but adding to the database will fail with an exception.See the extra code below 👇Docs 📑: <a href="https://learn.microsoft.com/en-us/ef/core/miscellaneous/collations-and-case-sensitivity" rel="nofollow noopener" translate="no" target="_blank">https://learn.microsoft.com/en-us/ef/core/miscellaneous/collations-and-case-sensitivity</a><a href="https://infosec.exchange/tags/dotnet" class="mention hashtag" rel="nofollow noopener" target="_blank">#dotnet</a> <a href="https://infosec.exchange/tags/entityframeworkcore" class="mention hashtag" rel="nofollow noopener" target="_blank">#entityframeworkcore</a> <a href="https://infosec.exchange/tags/effunctions" class="mention hashtag" rel="nofollow noopener" target="_blank">#effunctions</a> <a href="https://infosec.exchange/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://infosec.exchange/tags/collation" class="mention hashtag" rel="nofollow noopener" target="_blank">#collation</a>--- If you find this useful, consider giving a like & share ♻.

fip 🎶 #NowPlaying Bot🔊 <a href="https://mastodonapp.uk/tags/NowPlaying" class="mention hashtag" rel="nofollow noopener" target="_blank">#NowPlaying</a> on <a href="https://mastodonapp.uk/tags/fip" class="mention hashtag" rel="nofollow noopener" target="_blank">#fip</a>Collation: 🎵 Les couleurs<a href="https://mastodonapp.uk/tags/Collation" class="mention hashtag" rel="nofollow noopener" target="_blank">#Collation</a> <a href="https://open.spotify.com/track/5N5C0EFjw3sr3X3nXwM8Om" rel="nofollow noopener" target="_blank">https://open.spotify.com/track/5N5C0EFjw3sr3X3nXwM8Om</a><a href="https://collation.bandcamp.com/track/les-couleurs" rel="nofollow noopener" target="_blank">https://collation.bandcamp.com/track/les-couleurs</a>

christyotwisty 🇨🇦 (prime acc<a href="https://social.chaosmagick.com/@caliphora" class="u-url mention" rel="nofollow noopener" target="_blank">@caliphora</a> Dec 14 - 20 <a href="https://mstdn.io/tags/ProjektLunarSigil" class="mention hashtag" rel="nofollow noopener" target="_blank">#ProjektLunarSigil</a> <a href="https://mstdn.io/tags/AllTogetherNow" class="mention hashtag" rel="nofollow noopener" target="_blank">#AllTogetherNow</a> <a href="https://mstdn.io/tags/ToutEnsembleMaintenant" class="mention hashtag" rel="nofollow noopener" target="_blank">#ToutEnsembleMaintenant</a> <a href="https://mstdn.io/tags/Collation" class="mention hashtag" rel="nofollow noopener" target="_blank">#Collation</a> <a href="https://mstdn.io/tags/SigilBomb" class="mention hashtag" rel="nofollow noopener" target="_blank">#SigilBomb</a>

Recent searches

Search options

Administered by:

Server stats:

#collation