Language : French

Re: Language : French

jero01 — Thu, 30 Apr 2015 13:01:04 -0500

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

Re: Language : French

jero01 — Thu, 30 Apr 2015 00:46:12 -0500

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

Scott Finegan — Tue, 14 Apr 2015 19:34:22 -0500

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

jero01 — Tue, 14 Apr 2015 13:20:01 -0500

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

Scott Finegan — Mon, 13 Apr 2015 22:45:04 -0500

A search indicates the original character set was

Quote

No, Phorum was ISO-8859-1 in 5.1 and probably US-ASCII before that. But, UTF-8 has become the defacto standard for the internet.

from this topic [www.phorum.org]

Re: Language : French

Scott Finegan — Mon, 13 Apr 2015 22:30:42 -0500

I assume you have a copy of the file you can gunzip, and open in a text editor.
Look to see what character set was was specified on export.
Was it correct ?
Does it differ from Latin1?

You could try "alter table" to change the character set in the existing table. I change the create table statement in the dump/backup file to use the character set I want.

I used cpanel and dumped two databases. Both dumps showed the character set used when the table was created.

--
-- Table structure for table `lcc_dnschecks`
--

DROP TABLE IF EXISTS `lcc_dnschecks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lcc_dnschecks` (
  `dnsid` smallint(5) unsigned NOT NULL,
  `checkid` smallint(5) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `phorum5214_banlists`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phorum5214_banlists` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `forum_id` int(10) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `pcre` tinyint(1) NOT NULL DEFAULT '0',
  `string` varchar(255) NOT NULL DEFAULT '',
  `comments` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `forum_id` (`forum_id`),
  KEY `string` (`string`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

Re: Language : French

jero01 — Mon, 13 Apr 2015 19:06:08 -0500

Hello,

I backed up the database and copied it to the new server with cpanel.
I see now the defaults collation in the database are Latin1_swedish_ci.
What should I do?

Re: Language : French

Scott Finegan — Mon, 13 Apr 2015 17:21:54 -0500

Probably the mysql table has the incorrect character set selected. The defaults may have changed from the earlier mysql.

How did you create the tables, and import the data?

Re: Language : French

jero01 — Mon, 13 Apr 2015 16:51:26 -0500

Hello,

I had to move my installation (version 5.1.22) to a new server.
Everything went well except the message texts which appear like that now:
"je voudrai aborder un probl�me qui nous est cher � tous, "La sant�e""
Where all accented characters are replaced by a ? inside a lozenge but the menus are fine.
I have downloaded the French-UTF8 file from this page and in my default settings, I have selected French-UTF-8

Please help me solve this issue.

Re: Language : French

ghost2b — Tue, 22 Jan 2013 04:59:40 -0600

Bonjour, j'ai eu le même problème et j'ai trouvé la solution :
Pour les fichiers de langue il faut utiliser notepad ++ et convertir les fichier en UTF-8 (sans BOM).

Pour certains modules il manque les fichiers de langue, il suffit de créer un fichier "french.php" en traduisant le fichier de langue anglaise et on applique le même chose avec note pad ++ pour convertir en utf-8.

J'ai traduit l'aide pour les BBcode et les smiley en Fr, si besoin je mettrai les fichier à disposition.

Re: Language : French

sebremy40 — Tue, 24 Apr 2012 02:51:26 -0500

Bonjour,

En installant la version française sous 5.2.18 j'ai un problème de codage des caractères qui survient. Une idée ?

D'avance merci

Re: Language : French

bilbonsacquet — Mon, 09 Mar 2009 06:15:20 -0500

Version avec le bon "CHARSET" (UTF-8)

Re: Language : French

notre-planete.info — Tue, 23 Sep 2008 07:19:14 -0500

Fichier français mis à jour pour la version 5.2.8
Vous pouvez vérifier la localisation directement sur mes propres forums :
[www.notre-planete.info]

Updated version of french.php => 5.2.8
You can verifiy the translation on my own forums :
[www.notre-planete.info]

Re: Language : French

bilbonsacquet — Tue, 27 May 2008 12:39:36 -0500

Pour le fichier de langue : il faut le mettre dans le dossier "include" > "lang"

Ensuite la langue peut-être sélectionnée pour le forum, mais pas la partie administration.

Pour le reste : il faut poster dans la partie française du forum

Re: Language : French

pascuald — Tue, 27 May 2008 09:59:37 -0500

Bonjour ,

Le béocien cherche des infos pour ne pas crasher son petit travail

Tout d'abords, pouvons-nous discuter en français ???

Ensuite quelle est la marche à suivre pour mettre à jour mon phorum depuis la version 5.1 vers la 5.2 ??
J'ai téléchergé la version 5.2 et j'ai remplacé le logo par celui dont j'ai besoin mais j'ai peur de crasher mes préférences d'administrateur

Merci de l'aide

Pascal

Re: Language : French

bilbonsacquet — Tue, 27 May 2008 09:53:56 -0500

Quote
pascuald
Est ce qu'il y a une version récente du fichier que tu as mis en ligne pour la version française ??

J'ai modifié le fichier de traduction, il est dispo dans mon précédent message :
[www.phorum.org]

Quote
pascuald
Et est-ce qu'il est possible d'avoir l'administration en français ???

Malheureusement non, on ne peut pas traduire l'interface en question car les éléments sont directement "dans le code" du programme. Un jour peut-être ça sera possible, enfin j'espère !!!

Re: Language : French

pascuald — Tue, 27 May 2008 09:46:47 -0500

Bonjour Christophe ,

je suis béocien de chez béocien et j'ai choisi Phorum pour mon forum

Est ce qu'il y a une version récente du fichier que tu as mis en ligne pour la version française ??
Y a t-il eu des corrections depuis lors ??

Et est-ce qu'il est possible d'avoir l'administration en français ???

Cordial
pascal

Re: Language : French

wahren — Tue, 12 Feb 2008 15:07:01 -0600

Many thanks. It's OK now.

Re: Language : French

Maurice Makaay — Tue, 12 Feb 2008 14:45:11 -0600

Why change distro.php? You put the french.php next to the english.php. No need to delete the english.php like you seem to be doing. Then configure the default settings to use French. Also set the language to French in the forum settings for those forums for which you do not inherit the default settings. That is it.

Re: Language : French

wahren — Tue, 12 Feb 2008 14:41:22 -0600

Hi,

I have put your french.php file in the include\lang directory and replaced english.php by french.php in the distro.php file. Is that all what to do to complete the translation or is there something else to modify ?

Thanks for your reply.

Re: Language : French

bilbonsacquet — Sat, 12 Jan 2008 05:18:41 -0600

Duh !

$PHORUM['DATA']['CHARSET'] = "UTF-8";

was overided by :

$PHORUM['DATA']['CHARSET'] = "";

I've upload an "updated" version, so now it works as expected (no weird encoding)

Re: Language : French

bilbonsacquet — Thu, 10 Jan 2008 08:01:07 -0600

I've corrected some problems with missing "$ PHORUM" tags, typo or syntax mistakes, and I've changed the display date to some more "french" kind, and it's "of course" in "UTF8".

People must take care of the name of the file, french must be always named "french.php", some modules may not work if it's something different !

(EDIT: file removed see the next post)

Re: Language : French

Thomas Seifert — Fri, 04 Jan 2008 12:23:05 -0600

And attached is the same file just converted to UTF-8.
Thanks!

Language : French

notre-planete.info — Fri, 04 Jan 2008 12:05:54 -0600

The first 5.2 version of phorum in french.
You can verifiy the translation on my own forums : [www.notre-planete.info]
It's a reliable version but I can't assume that it's a perfect version.

The file is compatible with ISO-8859-1 characters.

I've updated the file (23/09/2008)