Encoding error PHP and MySQL for languages of Europe -


this question has answer here:

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

Popular posts from this blog

sql - VB.NET Operand type clash: date is incompatible with int error -

SVG stroke-linecap doesn't work for circles in Firefox? -

python - TypeError: Scalar value for argument 'color' is not numeric in openCV -