Encoding error PHP and MySQL for languages of Europe -
this question has answer here:
- utf-8 way through 14 answers
i want insert word languages of europe mysql. e.g á
, ó
, Ö
,ü
.(sorry, don't know language is. maybe can me fix title.)
but become can't read.
i try solution how inserting french characters in mysql db table?
i find out php version 5.1.6
. can't use mysql_set_charset
mysql charset utf8_general_ci
, version 5.0.45
.
how can fix problem?
db changes:
change charset in db, tables + columns (yes! changing table charset not enough, have column column! took me long time figure out!) "utf8"
change collation in db, tables + columns (really check every column) "utf8_slovak_ci"
import data , check looks fine in db
php changes:
when querying, use "mysql_query('set character_set_results = utf8;');" prior select/update statements
Comments
Post a Comment