Rolling back to earlier version of Virtuemart added  keys to database entries

heres what I ran in MySQL to sort this

UPDATE jos_vm_product SET product_s_desc = replace(product_s_desc,"Â"," ");


UPDATE jos_vm_product SET product_desc = replace(product_desc,"Â"," ");

UPDATE jos_vm_product_reviews SET comment = replace(comment,"Â"," ");

UPDATE jos_vm_category SET category_description = replace(category_description,"Â"," ");


If you are having problems with other values you could try these also



UPDATE jos_vm_product SET product_s_desc = replace(product_s_desc,"’","\'");

UPDATE jos_vm_product SET product_s_desc = replace(product_s_desc,"‘","\'");

UPDATE jos_vm_product SET product_s_desc = replace(product_s_desc,"“","\"");


UPDATE jos_vm_product SET product_s_desc = replace(product_s_desc,"Â"," ");

UPDATE jos_vm_product SET product_s_desc = replace(product_s_desc,"”","\"");

UPDATE jos_vm_product SET product_s_desc = replace(product_s_desc,"–","-");

UPDATE jos_content SET introtext = replace(introtext,"…",";");



UPDATE jos_vm_product SET product_desc = replace(product_desc,"’","\'");

UPDATE jos_vm_product SET product_desc = replace(product_desc,"‘","\'");

UPDATE jos_vm_product SET product_desc = replace(product_desc,"“","\"");


UPDATE jos_vm_product SET product_desc = replace(product_desc,"Â"," ");

UPDATE jos_vm_product SET product_desc = replace(product_desc,"”","\"");

UPDATE jos_vm_product SET product_desc = replace(product_desc,"–","-");

UPDATE jos_vm_product SET product_desc = replace(product_desc,"…",";");



UPDATE jos_vm_product_reviews SET comment = replace(comment,"’","\'");

UPDATE jos_vm_product_reviews SET comment = replace(comment,"‘","\'");

UPDATE jos_vm_product_reviews SET comment = replace(comment,"“","\"");


UPDATE jos_vm_product_reviews SET comment = replace(comment,"Â"," ");

UPDATE jos_vm_product_reviews SET comment = replace(comment,"”","\"");

UPDATE jos_vm_product_reviews SET comment = replace(comment,"–","-");

UPDATE jos_vm_product_reviews SET comment = replace(comment,"…",";");




UPDATE jos_vm_category SET category_description = replace(category_description,"’","\'");

UPDATE jos_vm_category SET category_description = replace(category_description,"‘","\'");

UPDATE jos_vm_category SET category_description = replace(category_description,"“","\"");


UPDATE jos_vm_category SET category_description = replace(category_description,"Â"," ");

UPDATE jos_vm_category SET category_description = replace(category_description,"”","\"");

UPDATE jos_vm_category SET category_description = replace(category_description,"–","-");

UPDATE jos_vm_category SET category_description = replace(category_description,"…",";");