UTF8 characters problem
Posted: Mon Aug 06, 2007 11:13 am
I hope someone can help me here . It is driving me crazy.
For the first time I am writing an application with utf-8 in the application and in the database.
for all my outputs I am using
htmlentities($data,ENT_QUOTES,'UTF-8')
also I am using in the header
meta http-equiv="content-type" content="text/html;charset=utf-8"
The database is all utf8 and utf8-general_ci (every character field with utf8)
Inside the application all the Spanish characters look fine. But if I see those characters using phpmyadmin or Navicat they look weird.
Before I used latin1 and spanish characters will look fine of the web and on the database and i did not have to do the htmlentities (altought I should have use it anayway).
What am I missing?? What is the secret formula to get this working??
For the first time I am writing an application with utf-8 in the application and in the database.
for all my outputs I am using
htmlentities($data,ENT_QUOTES,'UTF-8')
also I am using in the header
meta http-equiv="content-type" content="text/html;charset=utf-8"
The database is all utf8 and utf8-general_ci (every character field with utf8)
Inside the application all the Spanish characters look fine. But if I see those characters using phpmyadmin or Navicat they look weird.
Before I used latin1 and spanish characters will look fine of the web and on the database and i did not have to do the htmlentities (altought I should have use it anayway).
What am I missing?? What is the secret formula to get this working??