MySQL Gotcha

Subscribe to MySQL Gotcha 2 posts, 2 voices

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!!!!