Zen Cart Logo
Forums / General Questions / [HELP] mysql update to fix special characters lost on host switch

[HELP] mysql update to fix special characters lost on host switch

Locked

Views: 1,217

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
1 Feb 2008, 1:46 AM
#1
sgflowers avatar

sgflowers

Totally Zenned

Join Date:
Jan 2004
Posts:
508
Plugin Contributions:
0

[HELP] mysql update to fix special characters lost on host switch

Hi - when i switched hosts the database must have been a different character support

i now have a bunch of products where in the product description has replace special characters with a '?'

here is what i need to do

  • run a mysql operation via phpadmin that does the following

in the product title

  1. replaces 'FTD?' with 'FTD®'
  2. replaces '?' with '™'

what command can i run via phpadmin to accomplish this?

onvisoly i will backup the table before running it

2 Feb 2008, 10:12 PM
#2
sgflowers avatar

sgflowers

Totally Zenned

Join Date:
Jan 2004
Posts:
508
Plugin Contributions:
0

Re: [HELP] mysql update to fix special characters lost on host switch

can this be done via a mysql operation or do i have to export, fix the data and then import back in?