Re: 1064 error when exporting

[Javier Treviño]

Hi Nico,
Thanks for writing in our forums.

Just by looking at the error message you pasted here, I can think that you typed in something on the data type combo box for the `Research_Output_Category`column. The data type according to the error message seems to be "varc'" (with an apostrophe at the end of it). Can you confirm this?

A screenshot of the Export Data dialog before clicking Export and a copy of the generated SQL script for the "CREATE TABLE" statement would also help me troubleshoot your problem. To get the generated SQL script you need to go to the global options and check the setting to show SQL scripts before sending them to the server.

Best regards.

====================================
Javier Treviño
MySQL on Windows Team