mysql php encoding

Question

I have a mysql database that is UTF8 encoded. However, due to some previous conversion issues that I inherited, certain strings have been saved incorrectly to the database.

For example, £ should be saved as Â£, but in many places its been saved as something like Ãƒâ€šÃ‚Â£.

I have been able to track down all the records in the table that have been incorrectly encoded. Whats the easiest way for me to remove all the unncessary characters from this varchar database field?

I've tried preg_replace in php, but this doesnt seem to actually do anything.

return preg_replace("[^A-Za-z0-9£]", "", $string);

AndreKR · Accepted Answer · 2011-01-06 16:15:37Z

2

You must enclose the regex in delimiters:

return preg_replace("/[^A-Za-z0-9£]/", "", $string);

answered Jan 6, 2011 at 16:15

AndreKR

34k21 gold badges120 silver badges181 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Derek Downey Over a year ago

was in the process of that, so +1 for beating me

Derek Downey · Accepted Answer · 2011-01-06 16:19:34Z

0

What is being returned from that preg_replace call, an unaffected string or NULL? If it's null, then an error has occured according to preg_replace manual . Other than the missing delimiters that @AndreKR posted, it looks fine to me (tested with the string Ãƒâ€šÃ‚Â£)

answered Jan 6, 2011 at 16:19

Derek Downey

1,5322 gold badges10 silver badges17 bronze badges

Collectives™ on Stack Overflow

mysql php encoding

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related