How find and remove special chars in mysql?


I imported some data into a mysql data, but there are some special (MAC) characters which are coming as “question mark in a diamond” etc. I tried seraching and replacing for those chars in phpmyadmin but to no avail.

How can I replace those characters ? Some of them are like following:

Γäó ├⌐ ┬« ?�

Please help.


Do you have a meta tag like the following within your page’s head?

< meta charset=“UTF-8”>

It’s possible you are pulling information from a source that has characters not compatible with the character set declared in your meta tag.


Yes I have that tag in my webpage.


This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.