Some times I see strange characters when viewing the Shipping Options in a Miva Merchant store. This is because the characters are dependent on a character set. The way to correct this is to run the following command:
|
1 |
update s02_USPSMethods set name = replace(name, '�', '®'); |
It is semi safe to copy and paste the above command, ensure you change the s02 as needed. On a side note, this runs best from phpMyAdmin as pasting this in putty can cause problems with it matching the bad characters.
Leave a Reply