character é in the database

Hi,

The character é in the database are stored under this shape é.

if i update the database for change the é in é on the action table then in the application the action doesn't appear.


Why the characters is not stored under their initial shape.


I made a report with BO and the output is not good.

Thanks

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

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 :
editinmethod addbefore 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 !