scottydog72 Posted March 14, 2007 Posted March 14, 2007 Hi all, I've copied a data base to a new domain using phpmyadmin, it worked well apart from the (£) pound sign being replaced by a (?) question mark. It hasn't happened with other currencies. Any advice please.. Scotty.
Jack_mcs Posted March 14, 2007 Posted March 14, 2007 Try going to admin->Localization->Currency and change the symbol there. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
radders Posted March 14, 2007 Posted March 14, 2007 You need to set the default character set in mysql before you export if it hasn't already been set. If you don't do this your file will not be in any character set and the unusual characters will not be decoded on import into the new database. If you read the mysql forums there appears to be a bug report on this. The suggestion which worked for me was to set the default character set to Latin1 before exporting. Then when you import, tell mysql that the file you are importing is encoded as Latin1. How do you set this? In recent versions of phpmyadmin you can do this. Otherwise you may need to telnet in and use the unix command line.
scottydog72 Posted March 15, 2007 Author Posted March 15, 2007 You need to set the default character set in mysql before you export if it hasn't already been set. If you don't do this your file will not be in any character set and the unusual characters will not be decoded on import into the new database. If you read the mysql forums there appears to be a bug report on this. The suggestion which worked for me was to set the default character set to Latin1 before exporting. Then when you import, tell mysql that the file you are importing is encoded as Latin1. How do you set this? In recent versions of phpmyadmin you can do this. Otherwise you may need to telnet in and use the unix command line. Cheers, I'll lool into this, may be re-copy the database with changes.
scottydog72 Posted March 15, 2007 Author Posted March 15, 2007 Try going to admin->Localization->Currency and change the symbol there. Jack Cheers i'll give it a whirl....
scottydog72 Posted March 15, 2007 Author Posted March 15, 2007 Try going to admin->Localization->Currency and change the symbol there. Jack Worked a treat, simple when you know.. Cheers Scotty.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.