scottydog72 Posted March 14, 2007 Share 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. Link to comment Share on other sites More sharing options...
Jack_mcs Posted March 14, 2007 Share 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. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
radders Posted March 14, 2007 Share 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. Link to comment Share on other sites More sharing options...
scottydog72 Posted March 15, 2007 Author Share 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. Link to comment Share on other sites More sharing options...
scottydog72 Posted March 15, 2007 Author Share Posted March 15, 2007 Try going to admin->Localization->Currency and change the symbol there. Jack Cheers i'll give it a whirl.... Link to comment Share on other sites More sharing options...
scottydog72 Posted March 15, 2007 Author Share 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. Link to comment Share on other sites More sharing options...
radders Posted March 15, 2007 Share Posted March 15, 2007 Did it work also for your order history? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.