Currency Symbols messed up in CiviCRM 4.4

[jaapjansma]

I have the same issue on Ubuntu 12.04 did a clean install of civi 4.4.2 and a clean install of Drupal 7 yesterday.
My installation workflow was install in English. After installation I added the l10n package and set my language to Dutch and the currency symbol to Euro and now it shows some weird character instead of the euro sign.

[jaapjansma]

The problem with the messed up currency symbols is caused by the default charset of the mysql connection and client. This is set in your mysql.ini and in my case it was set to latin1.

So my connection from the civi installer to the mysql database had a character set as latin1.

There a few things to consider.
1. I have reported this as a bug in civicrm http://issues.civicrm.org/jira/browse/CRM-13946
2. Before installing civicrm set your database collation to utf8_general_ci after that the install goed correct
3. I have not found a solution to fix an already corrupted install

Jaap

[r4zoli]

I met same problem under xubuntu 12.04 with wordpress 3.7.1 and civi 4.4.2. The country, county and currency tables get the wrong coding, I used xubuntu with Hungarian language settings.

I installed in such way. Downloaded directly to the xubuntu download folder main and l10n package, unpacked both in download folder, copied files to the wordpress plugin folder all files.
The MySQL collation is set to utf8_general_ci before the civi installation.

I met this first when installed 4.4.alpha1 see: http://forum.civicrm.org/index.php/topic,29737.0.html

May be I wrongly assumed on that post, that the problem solved.

Something happened around this version.

[Donald Lobo]

r4zoli: can u test the patch submmitted by jaap

thanx

lobo

[r4zoli]

No help. I installed same way, the problems remains. I installed civi as Hungarian.

More problems with accented characters in main contact window email, phone, phone type, IM, dropdown selections.

[jaapjansma]

rz4oli: can you check what the collation you have on your database?

[Carlo Landmeter]

Please try this PR and see if it works:

https://github.com/civicrm/civicrm-core/pull/2195

[jaapjansma]

Hey Carlo,

I think you have made good solution for the installer.

Jaap

[geoadel]

Thanks Carlo,

I applied the one-line change and now the installation provided correct special characters for the currencies again.

Best regards,
Georg

[r4zoli]

Carlo patch works for me, too. On all earlier problematic places correct character when I made clean install, this solved my problems, too.

Thanks, Carlo.

Zoltán

[gmoe]

Hey Guys,

Any Fix for a corrupted Installation without installation.
My only Idea is to dump and coonvert the DB.

Any other Ideas?

[dfunes]

Hi,

I know that it's a sloppy solution but if you only have to change 2 -3 currencies, you can execute a sql command:

Code: [Select]

UPDATE `civicrm_crm`.`civicrm_currency` SET `symbol` = '€' WHERE `civicrm_currency`.`id` =3;
This worked for me.

[jaapjansma]

Thanks for the query.

Yes that would work if it is only about one or two symbols. But what you have to keep in mind is that all data which was loaded during the install is messed up. Most data is just plain ascii so you wouldn't see it because there is no difference.
So I would still recommand a re-install if you have messed up data. On the sites where I have discovered this issue, it was only on the test installs, not in productions.

[onglipo]

Had the same problem for Indian Rupee symbol.
UPDATE  `civicrm`.`civicrm_currency` SET  `symbol` =  '₹' WHERE  `civicrm_currency`.`id` =6;
Seemed to fix it.

[Coleman Watts]

To reiterate - fixing a single symbol in your db does not repair the entire db. Recommendation is to reinstall or at least rebuild that table.