Hi
I am having an problem updating property values from M-files to MySQL Server using the MySql ODBC Connector version 8.
I have been able to use the ODBC 3.51 connector with no issues. By inspecting the MYSQL log files the update command using ODBC 8 connector are sending strange characters and the where id match is always set to 0.
ODBC 8 data passed to MySQL:
Query UPDATE customer SET firstName = 'test name', shop = '\0\0st shop' WHERE customerID = 0
ODBC 3.51 data passed to MySQL:
Query UPDATE customer SET firstName = 'test name', shop = 'test shop' WHERE customerID = 3
M-Files server version is 19.9.9114.8
Have anybody come across this issue and have a solution to fix it. My issue is that with our newer MySQL server the 3.51 connector does not work.
The issue was resolved by installing M-files server version 19.11.8489.2
