As of MySQL 5.0.3, a BIT data type is available for storing bit-field values. (Before 5.0.3, MySQL interprets BIT as TINYINT(1).) In MySQL 5.0.3, BIT is supported only for MyISAM. MySQL 5.0.5 extends BIT support to MEMORY, InnoDB, BDB, and NDBCLUSTER.

To convince your JDBC driver to show you tinyint for the tiny little int that it actually is, rather than as a boolean, try setting the tinyInt1isBit=false parameter when connecting.

If you are trying to get some custom macros to work with Outlook as outlined, for example, here and here, you may be befuddled to discover that that your macros fail silently; usually after restarting Outlook. This is because Outlook is quietly disabling all macros because it hates youI mean, because it doesn’t trust you. That is to say, it doesn’t trust your self-signed cert.

In Windows 7 it appears as though self-signed certs have to first be copied into a “trusted” group before they can be used. Here’s how to do it:

Run certmgr.msc as an Administrator.

Open the “Personal” tree node in the left pane.

Open the “Certificates” node under the Personal node.

Note that your self-signed certificate appears in the right pane. It may have a red “X” through it.

Double-click the certificate in the right pane to see instructions about copying the certificate to the “Trusted Root Certification Authorities” store. Good thing these important details are so easy to discover.

Hold down the control key and drag the cert into “Trusted Root Certification Authorities > Certificates” which should appear immediately below the Personal node.

Follow any prompts to completion. The red “X” should disappear and your cert should know have a key icon attached to it.