Quote:
Originally Posted by caldunk
I was experiencing the same problem you posted here
and your solutions
'It is UTF-8 as I can see chinese characters.
After a long struggle, I manage to resolve it by re-definite it as binary.
Anyway, it seems that backing up with phpMyAdmin and restoring it will not be the same as default. Now I am using a online database backup to backup and restore. That works.'
How do you redefinite it as binary?
and how do you do the online db backup to backup and restore?
THanks.
|
In the phpMyAdmin, under the collation, you can set it as binary. Depending on the version of your phpMyAdmin as lower version does not show the Collation as I have some servers does not show the collation field.
For the online db backup, it is a separate software that I have installed in the server that allows me to backup and restore with the same setting. Unlike using phpMyAdmin, it does not give back the same setting when changing server.