ODBC Error (Server dose not support 4-byte encoded UTF8 characters)
Operating system version
Description of the issue
I'm trying to use FileMaker to upload data to MySQL database table so that it can be used on the website.
I was able to successfully get this working when I'm using FileMaker 12.
I have tried different versions of the ODBC Connector Driver but get the same results, no matter what i do i keep getting that error message every time i try to make changes using FileMaker 13.
I have tried disabling 360Works Plug-In and restarting FileMaker, still no results.
I seems to be having problem changing fields that are "TEXT" or "CHAR" format in MySQL.
Steps to reproduce the problem
1) Install ODBC Connector Driver (v5.2.4) on the server
2) Open "ODBC Data Source Administrator (64-bit)"
3) under "System DSN" click ADD and fill out all the needed info to connect to SQL server database
4) Open FileMaker and go to "Manage External Data Sources"
5) Click "New" and then assign: name, type=ODBC, under "DSN" click specify and you should see the "Data Source Name" that you named the connection on the server side.
6) select it and click OK and OK. (Connection is established now)
7) Go to "Manage Database" under "Relationships" click add a Table
8) pick "Database Source" (name of MySQL that you gave)
9) select table and click OK
10) go to that tables layout and try changing existing data or adding new record.
11) ERROR message some up every time you try to alter any "TEXT" or "CHAR" fields.
Expecting for it to make changes to the MySQL database table without any error messages, which will allow importing process to go through successfully.
Exact text of any error message(s) that appear
ODBC Error: [MySQL][ODBC 5.2(w) Driver][mysqld-5.1.58]Server does not support 4-byte encoded UTF8 characters.