how to convert é,ê,… in database mysql to the no

Question

There are the problems of data in mysql.

Some data store with the string like (1):"hello & hello ' hello è ...". And some data store with the string like (2):"hello à hello é hello ê ...".

I can solve the string (1) to the normal string, but I don't know how to convert the string (2) to the normal string?

Note : We can not change the data in the existing database :/ Also the both sample is store in the same table and the charset of the table is latin1!

Answer 1

hello à hello é hello ê probably is UTF-8 interpreted as ISO-8859-1.

You can either change the interpretation, e.g. in a browser set a charset, or convert it to ISO-8859-1 using utf8_decode().

Answer 2

Use CONVERT as CONVERT ("hello à hello é hello ê ...", ascii) ....

Answer 3

EDIT-

Without changing the DB structure try this --

ini_set('default_charset', 'YOUR_CHARACTER_SET')

OR try this --

header('Content-Type: text/html; charset=iso-8859-1');

Check this setting, its all bcoz of table collation