Edventures in Normalcy

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, '�', '®');

Now because I took the time to make sure the above command displays as should be run, it is semi safe to copy and paste it, 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

 
Copyright © Edventures in Normalcy. All rights reserved.