Quote:
Originally Posted by TigerFeet
I exported the table I had changed into SQL format (using navicat) but can't get them import into the new database.
|
As far as exporting tables using Navicat, (I use this myself), when it generates the sql file, it will add this line to it : SET NAMES utf8mb4;
That "utf8mb4" needs to be changed to just utf8 (without the mb4). I usually just dump the table, then open it up with an editor (like notepad++) to correct that, then source it into database.