Character encoding problem

[VitorFF]

Hello guys!

I found a strange issue on out system regarding character encoding. It is quite possible that this issue happened after an upgrade form 4.4.6 to 4.4.11.

In our CiviCRM backend all characters look perfect, but when data is rendered on our front-end page some characters are not showing properly (as is visible on the attached screenshots).

Another weird thing about this issue is that on our local development installations this problem doesn't happen. Is it possible that during the upgrade some configuration got deleted/changed?


Thank you for your time guys!

VitorFF
 

[mathieu]

Hi,

Can you compare the table definition between your local dev site, and the production site?

ex:

Code: [Select]

show create table civicrm_contact;

More specifically, since the above will output a huge table definition, I'm curious about the part with "CHARSET=utf8 COLLATE=utf8_unicode_ci". It should be at the end completely of the table, but the collate should also be on the first_name, display_name, etc.

Mathieu

[VitorFF]

Hello Mathieu,

I've compared the tables and they are the same.

Note that this doesn't happen only on the contact table.


Thank you for your help.

[Hershel]

Another weird thing about this issue is that on our local development installations this problem doesn't happen. Is it possible that during the upgrade some configuration got deleted/changed?

It's possible. Was your development upgraded? Can you upgrade one and see?

Also could you install a fresh copy of 4.4.11 on your live server (just temporarily to get the DB to install) and then compare a dump of the structure only for that vs. your live DB?