ClueTrust KB

Unknown system variable 'character_set_results'

If you encounter an error similar to this, it is likely because you are using the 5.x ODBC connector on your Macintosh and a version of MySQL older than 4.1 on your server. There are two known solutions to this: use a pre-4.1 ODBC connector, or upgrade your database to a post-4.1 version. This is a bug in the ODBC connector, and doesn't appear to be queued for a fix.

ODBC doesn't work on 64-bit machines

We have encountered problems in 64-bit mode using many ODBC drivers, including: the standard-built MySQL components, those included with FileMaker Pro (including the newly-released version 10), and those by Actual Technologies. As of this writing, they are not built multi-platform and don't have 64-bit components to the library. As such, the 64-bit version of Cartographica cannot talk to them.

In order to get around this, you'll need to either build 64-bit ODBC libraries from the source code (a possibility in the case of the MySQL drivers), or run Cartographica in 32-bit mode.

Since we see this as a temporary problem (hopefully) until the driver folks get their drivers working for 64-bit, we've got two small applications that will launch Cartographica in 32-bit mode, one for PowerPC and one for Intel. These can be downloaded from our website and will work as long as Cartographica is installed in the /Applications folder.

Problems with FileMaker Pro

The FileMaker Pro ODBC drivers are a bit funky (don't take our word for it, do a search for them and see for yourself). However, we have put a special detector in builds 133 and beyond that notice we're talking to FileMaker Pro and take special precautions. Since some of the peculiarities don't work with other drivers, we have to special-case talking to FileMaker Pro, so if you see any anomalies, please report them using our bug report form.