MyPHPAdmin database import

[lee the bean]

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?

[ricksteruk2005]

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.

[burt]

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`, "?", "£");