Firefox PHP

Language : French

Posted by notre-planete.info 
Re: Language : French
April 14, 2015 08:20PM
Thanks Scott,

Yes the tables were in ISO-8859-1 and I see that when I change the collation in phpmyadmin, the characters change but I can't seem to get the correct one.
ISO-8859-1 is not a part of the choices in MYSQL so I don't know what to choose.
Now I am getting "," instead of all accented characters: "Le roi Salomon nous donne donc de tr?s bons exemples ? suivre"
What should I do?
Should I encode my DB in another format (UTF-*??for example) and re-copy it to the server?
Re: Language : French
April 15, 2015 02:34AM
Using a copy of the sql file change the create table statement(s) to use utf8 and see if it works.

Go to this page and read... [dev.mysql.com]
Re: Language : French
April 30, 2015 07:46AM
Do you mean like that?

-- Table structure for table `phorum_messages`
--

CREATE TABLE IF NOT EXISTS `phorum_messages` (
`message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`forum_id` int(10) unsigned NOT NULL DEFAULT '0',
`thread` int(10) unsigned NOT NULL DEFAULT '0',
`parent_id` int(10) unsigned NOT NULL DEFAULT '0',
`author` varchar(37) NOT NULL DEFAULT '',
`subject` varchar(255) NOT NULL DEFAULT '',
`body` text NOT NULL,
`email` varchar(100) NOT NULL DEFAULT '',
`ip` varchar(255) NOT NULL DEFAULT '',
`status` tinyint(4) NOT NULL DEFAULT '2',
`msgid` varchar(100) NOT NULL DEFAULT '',
`modifystamp` int(10) unsigned NOT NULL DEFAULT '0',
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`thread_count` int(10) unsigned NOT NULL DEFAULT '0',
`moderator_post` tinyint(3) unsigned NOT NULL DEFAULT '0',
`sort` tinyint(4) NOT NULL DEFAULT '2',
`datestamp` int(10) unsigned NOT NULL DEFAULT '0',
`meta` mediumtext NOT NULL,
`viewcount` int(10) unsigned NOT NULL DEFAULT '0',
`closed` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`message_id`),
KEY `thread_message` (`thread`,`message_id`),
KEY `thread_forum` (`thread`,`forum_id`),
KEY `special_threads` (`sort`,`forum_id`),
KEY `status_forum` (`status`,`forum_id`),
KEY `list_page_float` (`forum_id`,`parent_id`,`modifystamp`),
KEY `list_page_flat` (`forum_id`,`parent_id`,`thread`),
KEY `post_count` (`forum_id`,`status`,`parent_id`),
KEY `dup_check` (`forum_id`,`author`,`subject`,`datestamp`),
KEY `forum_max_message` (`forum_id`,`message_id`,`status`,`parent_id`),
KEY `last_post_time` (`forum_id`,`status`,`modifystamp`),
KEY `next_prev_thread` (`forum_id`,`status`,`thread`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF-8 AUTO_INCREMENT=99302 ;
Re: Language : French
April 30, 2015 08:01PM
I changed UTF-8 to utf8
But I am still getting this instead of accented characters

"parent� avec C�sare BEH n�e � Orn qui a habit� � "

Please help me
Sorry, only registered users may post in this forum.

Click here to login