如何使用php将数据库mysql中的é,ê,...转换为普通字符串é,â,...? [英] how to convert é,ê,... in database mysql to the normal string é,â,... using php?
问题描述
mysql中存在数据问题.
某些数据存储区,其字符串如(1): "hello & hello ' hello è ..."
.还有一些数据存储,其字符串为(2): "hello à hello é hello ê ..."
.
我可以将字符串(1)解析为普通字符串,但是我不知道如何将字符串(2)转换为普通字符串?/p>
注意:我们无法更改现有数据库中的数据:/ 同样,这两个样本都存储在同一张表中,并且该表的字符集是latin1!
hello à hello é hello ê
可能是UTF-8解释为ISO-8859-1.
您可以更改解释,例如在浏览器中设置一个字符集,或使用utf8_decode()
将该字符集转换为ISO-8859-1.
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!
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()
.
这篇关于如何使用php将数据库mysql中的é,ê,...转换为普通字符串é,â,...?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!