Hello,
I got a charset problem in a french forum :
http://www.deathblow.cc/index.php?n=forum
Here’s the details of the problem :
– When posting a message with any accent on it inside the forum (é,à,è,ô,ê, etc…), the message is cut at this first accent.
For example, if i put a message while posting in forums like “Vais-je arriver à faire marcher l’encodage de mon site un jour”.
The result is “Vais-je arriver “…
If we modify directly an existing word directly to the database with SQLYog for example : The word “Boite a Idee” to “Boite à Idée”.
Display on forums : “Boite à Idée”
Please try by creating an account on website and posting somewhere to test.
———————————————————————
The server run on Debian Lenny en 64 bits with Plesk 9.5.
We got root on the server.
Here what we have done to try to correct the problem :
1. Check locales on server UTF-8, ISO-8859-1 and ISO-8859-15 is correctly installed.
2. Modify file /etc/apache2/conf.d/charset with inside :
AddDefaultCharset ISO-8859-15
Then restart apache2
3. Modify cms header with :
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<html xmlns=”http://www.w3.org/1999/xhtml” xml:lang=”fr” lang=”fr”>
<head>
<meta http-equiv=”content-type” content=”text/html; charset=iso-8859-15″/>
4. Add .htaccess content to any folder :
AddDefaultCharset ISO-8859-15
php_value default_charset ISO-8859-15
5. Investigated the forum topic table with the mysql command line :
ALTER TABLE f_forums CONVERT TO CHARACTER SET latin1 COLLATE latin1_general_cs;
6. Changed mysqld config :
[mysqld]
init-connect =’SET NAMES latin1′
7. Put in my.cnf in section [mysqld] [mysql] and [mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1
Then, no changes ! Start to pulling my hair !
I think Developer who bid must have knowledge on :
– php
– mysql
– Linux debian
Thanks for bidding
