USPS character encoding issue for shipping in Miva Merchant

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:

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

Your email address will not be published. Required fields are marked *