CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • Character encoding problem
Pages: [1]

Author Topic: Character encoding problem  (Read 347 times)

VitorFF

  • I post occasionally
  • **
  • Posts: 35
  • Karma: 1
  • CiviCRM version: 4.4.11
  • CMS version: Drupal 7.27
  • MySQL version: 5.5
  • PHP version: 5.4
Character encoding problem
February 18, 2015, 04:53:26 am
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
 
Why don't you take a look at this? (You will not regret it!)

Capitalisation Corrector : https://civicrm.org/extensions/capitalisation-corrector

mathieu

  • Administrator
  • Ask me questions
  • *****
  • Posts: 620
  • Karma: 36
    • Work
  • CiviCRM version: 4.7
  • CMS version: Drupal
  • MySQL version: MariaDB 10
  • PHP version: 7
Re: Character encoding problem
February 18, 2015, 08:08:08 am
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
CiviCamp Montréal, 29 septembre 2017 | Co-founder / consultant / turn-key CiviCRM hosting for Quebec/Canada @ SymbioTIC.coop

VitorFF

  • I post occasionally
  • **
  • Posts: 35
  • Karma: 1
  • CiviCRM version: 4.4.11
  • CMS version: Drupal 7.27
  • MySQL version: 5.5
  • PHP version: 5.4
Re: Character encoding problem
February 18, 2015, 08:49:14 am
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.
Why don't you take a look at this? (You will not regret it!)

Capitalisation Corrector : https://civicrm.org/extensions/capitalisation-corrector

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Character encoding problem
February 18, 2015, 09:04:55 am
Quote from: VitorFF on February 18, 2015, 04:53:26 am
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?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • Character encoding problem

This forum was archived on 2017-11-26.