User forums now online! Please see the latest post in the Announcements forum for more information.

Author Topic: Thumbsplus 10 MySQL database Collation Issue  (Read 1139 times)

0 Members and 1 Guest are viewing this topic.

tsmithf

  • New member
  • *
  • Posts: 1
    • View Profile
Thumbsplus 10 MySQL database Collation Issue
« on: 2015-12-08 08:29:49 »
Hi, were have installed Thumbsplus to use a central MySQL database, we tried MariaDB but couldn't get it to work.

We have installed the latest version of MySQL database on a 2012 R2 server fine and used the V9 script succesfully, and created the ODBC Connectors, which connect succesfully.

Thumbsplus 10 is working and using the central database on the our workstations, however we are getting a few errors relating to collation of the database.

Initially using the script the connection was very slow and threw up multiple collation issues, so we changed the database tables to Character Set: utf8 & Collation: utf8_general_ci, which seem to fix most of the errors.

However we are still getting a few errors...

[MySQL][ODBC 5.3(a) Driver][mysqld-5.7.9-log]Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='

with a ThumbsPlus error <5015.8033>

Can you confirm what Character Set and Collation each of the tables should be using, or if it's related to a different issue.

Thanks

Trevor