| Export and import MySQL via phpMyAdmin (collation = latin1_swedish_ci) |  |
 |
| Written by Administrator |
|
Source MySQL If tables’ collation is latin1_swedish_ci, 1) the MySQL 文字編碼 must be ISO 88591- West European(latin1) 2) localhost > MySQL Collation 連線校對 must be set to latin1_swedish_ci before exporting the database.
Recipient MySQL Same as the above, localhost > MySQL Collation must be set to latin1_swedish_ci before importing the database.
However, the MySQL 文字編碼 NO NEED to set to ISO 88591- West European(latin1), “UTF-8 Unicode (utf8)” is ok.
When uploading and importing the *.sql, choose “latin1” as follows:
|
| Last Update (週六, 07 三月 2009) |