Apache Friends Support Forum

Is there anyway to remove this default collation of latin_general_ci to blank?

When I upload my test database to my website, I have to delete each instance of this in the SQL statement.

Wonderful product though!! Works like a charm...

When I upload my test database to my website,

That's not correct:
At your online server you import a dump, that you have exported at your local server.

I have to delete each instance of this in the SQL statement.

If your online server does not understand collations, then this server must be an older version as your local server. In this case, you must use the compatible mode for the export.