|distler 100 posts||
If you’re going to use Heterotic Beast in production, you need to be running MySQL 5.5.3 or later, and follow the advice in this blog post.
Otherwise, the lack of support for Unicode will come back to bite you.
|edwardsantiago 4 posts||
There is another gotcha in the NULL handling: If you define a column as NOT NULL and query the table with a IS NULL condition this should return no rows. But MySQL knows that the column cannot be NULL, thus simply “optimizes” the IS NULL condition away and returns all rows!!!!