Why is my BOOLEAN filter not working?

If you are using a BOOLEAN filter and you get an error like this:

Check if your database supports TRUE/FALSE values. Certain databases, like MySQL, only support 0 and 1.