428050 Charset problem on forum
N/A
Publicado há mais de 13 anos
Hello,
I got a charset problem in a french forum :
[login to view URL]
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" "[login to view URL]">
<html xmlns="[login to view URL]" 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 [login to view URL] 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
ID do Projeto: 2173920
Sobre o projeto
Projeto remoto
Ativo há 12 anos
Quer ganhar algum dinheiro?
Benefícios de ofertar no Freelancer
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
É grátis para se inscrever e fazer ofertas em trabalhos