Just change the table collation

  • Table collation is set to latin1 instead of utf8

    I just found out about this problem. The table should have been set as utf8 instead of latin1. I had to manually fix it in my installation but the developer must do that on the plugin level.

Viewing 2 replies - 1 through 2 (of 2 total)

  • Wow… That’s a very critical review! I could maybe understand a 3 star…

    Here is how the logic currently works for this issue. The logic for SHOW CREATE TABLE will create the charset based on how the database currently has it set. So if you create a package and your database has it set as ‘latin1’ then that is how the MySQLs show create will generate the SQL:

    CREATE TABLE your_table (
    YourColumns…
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    From what I understand you have to convert from a latin1 to utf8 manually as described in this article. Just manually changing it in the SQL script can cause issues and doesn’t always work with all the different conversion types. Changing character collation can be a complex issue and really isn’t the purpose of the plugin at this phase in its development.

    The plugin is still in beta and working through these issues is a complex process. If you have any suggestions for work-arounds to the solution I would be willing to investigate them, however trying to fit the procedures of the article above into the plugin would be very difficult.

    Please re-consider your review…

    Thanks~

    Thread Starter EOSlover

    (@eoslover)

    Sorry, I thought your plugin was making all the problems because the table was latin1. Plugin worked fine.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Just change the table collation’ is closed to new replies.