You Database is not set to UTF8 format !
You must change parameter character_set_server in php.ini file

Hi Laudoin,

I have exactly the same trouble as you.

After update the param character_set_server in database to utf8, the character é is well display, but the page from projectorria not display the value.

here my database parameters obtained by the command

 SHOW VARIABLES LIKE 'c%'

character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
collation_connection utf8_general_ci
collation_database utf8_general_ci
collation_server utf8_general_ci

I have found a solution with the encoding problem.

My database config is :
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
collation_connection utf8_general_ci
collation_database utf8_general_ci
collation_server utf8_general_ci

But the datas store in database seem to be in latin1 "é" is display as "é" despite the database is in utf8.

Here the following steps to fix this problem :
1/ Dump your database with the command "mysqldump YOURDATABASE -uYOURUSER -p -r thefiletosaved.sql" or phpMyAdmin or MySQLWorkbench...
2/ Edit the file for example with notepad++
3/ convert the encoding file in utf8 without bom, in footer notepad++ you will see the encoding. It must be utf8 without BOM. After do that, the accents in the file are well display.
4/ Drop your database
5/ Create your database
6/ Load the SQL file converted in the database. After that in database the accents seems well display.
7/ Last problem Projectorria dont display correctly the accents, to solve this problem :
edit

model/persistence/Sql.php

in

getConnection

method add

mysql_query("SET NAMES UTF8");

before the last line (return self::$connexion;)

And the application well displays correctly the accents.

Best Regards,

Hi,

I have the same DB config and I have the same problem since i updated project'or'ria to v2.6.3. All accents are well displayed in my database but in the application they are not displayed or replaced by "�".

I don't really want to rewrite one by one each entry of m DB...
Do anyone else have the problem, have you a solution to fix it?

Thanks a lot !

When upgrading to V2.6.3, did you copy your database ?

When copying one database through Export / Import, if database encoding is not exactly configured the same, you'll face charset issue.
Most of the time, you can fix it converting exported file with an external tool (notepad++ or else).

Hi, Tanks for your response. I tried several things :

First : I copied my existing DB in a new DB for update
Second : Creating a new DB then copy my existing data in the new DB
Third : Export $ import

When i correct an accent from the application, he's encoded in latin1 in my DB like this : "testaccenté". Despite of my DB configuration :

character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
collation_connection utf8_unicode_ci
collation_database utf8_general_ci
collation_server utf8_general_ci