How find and remove special chars in mysql?

Databases
1

Hi,

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.

Thanks.

2

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.

3

Hi,

Yes I have that tag in my webpage.

Thanks.

4

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