Hi everyone,
I need some help with the following issue :
The accentuated characters of the content taken form the UTF-8 database gets garbled once displayed on my website.
What I don't understand is that everything seems to be properly set :
mysql.ini
PHP header
Metas
Table structure
So, what else could cause the problem?
I am at a total loss of ideas after extensive googling
Thanks for the help!
I need some help with the following issue :
The accentuated characters of the content taken form the UTF-8 database gets garbled once displayed on my website.
What I don't understand is that everything seems to be properly set :
mysql.ini
Code:
[mysql]
default-character-set = utf8
default-character-set = utf8
character-set-server = utf8
collation-server = utf8_general_ci
init_connect = 'SET collation_connection = utf8_general_ci'
init_connect = 'SET NAMES utf8'
PHP header
Code:
header("Content-Type:text/html; charset=utf-8");
Metas
Code:
<meta http-equiv="content-type" content="text/html;charset=utf-8">
Table structure
Code:
CREATE TABLE `mod_geonames` (
`geoname_id` mediumint(9) NOT NULL,
`name` varchar(200) default NULL,
`latitude` decimal(10,7) default NULL,
`longitude` decimal(10,7) default NULL,
`country_code` varchar(2) default NULL,
PRIMARY KEY (`geoname_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
So, what else could cause the problem?
I am at a total loss of ideas after extensive googling
Thanks for the help!