Today I am going to explore MySQL’s Binary Collations. About a week ago, I wrote a post about an issue I was having with trailing whitespace not showing up as a different value in a GROUP BY query as I expected. As a brief recap, this is because the MySQL character set I was using [...]
I recently had a run-in with a very interesting MySQL “issue”. I place issue in quotes because it is not a bug, and it’s well documented. However it was not something I came across before and the behavior is not intuitive to me. Without getting into too much detail about the specific use-case, the issue [...]
When I first started setting up this site using WordPress as a CMS, I reviewed some existing code for themes and plugins. Among the garbled mess of code, I found a pearl: the glob function The glob function, in a nutshell, provides a means of retrieving a list of files that match a pattern. A [...]