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

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - tsmithf

Pages: [1]
1
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

Pages: [1]