Error running dap --loglevel info initdb --table courses

Jump to solution
daniel_powers
Community Explorer

I am getting an error running DAP (version dap 0.3.14) initdb for our MySQL courses table. The error message is "Incorrect string value: '\\xE2\\x80\\xA8200...' for column 'syllabus_body' at row 96"). The course ID is 7751. The full command is:

dap --loglevel info initdb --table courses

A redacted log file is attached.

 

0 Likes
1 Solution
daniel_powers
Community Explorer
Author

The issue is related to the handling of utf8 data by our older, MySQL 5.7 database. The issue was resolved by altering the database to use the newer MySQL utf8 character set and collation. The resolution was described here: 

https://dba.stackexchange.com/questions/8239/how-to-easily-convert-utf8-tables-to-utf8mb4-in-mysql-5...

View solution in original post