AutoIt-Access Database-mdb-accdb-files

Just an fyi, I found a solution that works for accessing fields’ values to a MS Access database. The code works for .mdb and .accdb files where the latter file extension applies to Access 2007. Just go here: AutoIt: Connecting to Access Database.

Incorrect string value: ‘\x99 is y…’ for column

If you receive this error from MySQL when inserting text in your column or some other similar error as:

Incorrect string value: ‘\xC2\x99 is …’ for column

then it most likely has something to do with the characters that are attempted to be inserted.

View these MySQL postings:
http://bugs.mysql.com/bug.php?id=30131
http://bugs.mysql.com/bug.php?id=33475

One workaround is to create external files with these characters and [...]