lee the bean Posted November 17, 2009 Share Posted November 17, 2009 I have successfully setup a duplicate oscommerce site for development work (fed up of hacking my live code). Thanks to all who have provided very good information on how to do this... However, after I import my database, pound signs (£) are imported as question marks (?). The symbol can be changed afterwards via - admin currencies - however this doesnt change the database records in stored orders (for example). The only import option I can find is utf8 (i think), but am unsure if this is the option to get pounds signs? Any one? Link to comment Share on other sites More sharing options...
ricksteruk2005 Posted November 17, 2009 Share Posted November 17, 2009 I have had the same problem in the past. Do you upload the file as a .txt file (this is what i use to do) Instead once I have finished editiing the file I save it as shop.SQL and then upload it. I have found that this solves the problem. I dont help with templates (thats what the seller is for) th search function will often help, when it dont try this in google. site:http://www.oscommerce.com/forums then your search word Link to comment Share on other sites More sharing options...
burt Posted November 17, 2009 Share Posted November 17, 2009 You could run a sql squery to the DB to change all occurences of ? to £ This should do it, you shuld obviously backup your database before running anything on it; UPDATE `orders_total` SET `text` = REPLACE(`text`, "?", "£"); Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.