Skip to content

Bug: Mismatch between database and Currency.php

Hello,

Currencies obey to this format in the Currency.php file: "Country, Currency" I don't know why but I accept it as a fact.

However some currencies don't obey to this format:

Iraqi Dinar
Zimbabwe Dollars
CFA Franc BCEAO
CFA Franc BEAC
CFP Franc
Maldivian Ruffiya
Ugandan Shilling
Sudanese Pound

Some of these use for format adjective+currency "Sudanese Pound" instead of "Sudan, Pounds" (poundS with an S)

Iraqi Dinar
Maldivian Ruffiya
Ugandan Shilling
Sudanese Pound

Some forget the comma

Zimbabwe Dollars

Some forget the country

CFA Franc BCEAO
CFA Franc BEAC
CFP Franc

which should be

BCEAO, CFA Franc
BEAC, CFA Franc
French Pacific's Territorial Collectivity, CFP Franc

Because of that, the currencies are not displayed correctly and it becomes really obvious when a language other than english is used

See also

modules/Migration/schema/600_to_610.php:    Migration_Index_View::ExecuteQuery('INSERT INTO vtiger_currencies (currencyid,currency_name,currency_code,currency_symbol) VALUES ('.$adb->getUniqueID("vtiger_currencies").',"Sudanese Pound","SDG","£")',array());