Affilistore Content Units: Currency not displayed correctly

Just a very quick tip. For situations such as this in WordPress.

Outside of Affilistore, content units often fail to display the currency symbol correctly. Instead they show a square symbol. It is not an issue with your server, dedicated or not … the issue will crop up according to the script that is in use.

Now, whilst this may primarily be down to the character set being used within a particular environment, it will not always be practical to recode the character set in each scenario. The simple solution would appear to be that you change the currency symbol at the point of creating the feed.

So e.g. instead of £ … enter £

            instead of $ … enter &USD;

or find the appropriate currency interpretation for your locale.

This should mean that anywhere you use the contentunit, the correct symbol is displayed.

If you want to change this for existing Affilistore feeds, then you need to run some MySQL through PHPMyAdmin or similar as follows (substituting the correct currency in both parameters of the replace function):

UPDATE affilist_config SET value = replace (value,’-:-$-:-’,'-:-&USD;-:-’) WHERE name LIKE ‘feedMemory%’;

That should solve the square currency problem in any sutuation.