Tag Archives: mysql

About MySQL, UTF-8 and saving headaches

One of the most confusing topics ever in web development history is character sets. MySQL has a lot of features to help you with this, but when things go wrong, it can be a real pain to get it solved. Read this and fear no more.

Don’t fear the MySQL geekness!

I have quite often seen people wrestle with easy problems. The trouble is, they don’t really know the ins and outs of systems they work with. Very few times this was unresolvable by a bit more knowledge of how the software is used at a very basic, low level.

MySQL: ENUM’s and booleans

This is one i ran into a few years back, when an entire project was built on a database using ENUM’s as bools. Unfortunately, it was for me to figure out what caused some weird bugs involved. This is a run-down of what happens when you actually use ENUM’s as (evaluating) bools: