Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

order currency stored as £ instead of ?


brianstorm

Recommended Posts

Posted

Hi,

 

my MS2 shop is storing order totals as with £ as a currency... the shop displays this as a ? sign but emails are sent as plain text and show up the £....

 

This is a centos4 server running apache2....

 

 

Does anyone know what might be casuing this and how to fix it?

 

locale in /includes/languages/english.php is set to

@setlocale(LC_TIME, 'en_GB.ISO_8859-1');

 

 

any advice or ideas much apprecciated...

 

 

brian

with ten thousand dollars we'll all be millionaires

Posted

Took me forever to figure that out.

 

You have to go into your database table currencies and put this in the Symbol Left or wherever you want the symbol to show column.

 

EURO Symbol Code:

 

 

When I paste the code in the forum it coverts it so I am writing the instruction manually for you to type in.

 

First symbol is the & sign

Second symbol is the # sign

Than the numbers 8364; (note the apostrophe at the end is part of the code)

 

No spaces between .. all one line.

Posted

Sorry that was for the EURO

 

British pound use the & plus the # plus 163;

 

or you can try & plus the word pound

 

 

As stated above .. you might get away with entering it in the admin currencies Symbol Left input field. I had to actually enter it directly into the database field for some reason.

Posted

Hi,

 

thanks for the reply...the currency does display fine on the store, its just that the orders are stored in the database with the currency as £, and order emails are sent out with £ as the currency.... this is not ideal... i am thinking that this may be at a server level (locale?) but the oscommerce locale is set the same as one which I have on another server and that works perfectly...

 

I have been looking through the literature for the server (centos4) and apache and haven't found anything that helps yet so i think i'm looking in the wrongplace.... any help would be much apprecciated as i am stumped....

 

(non oscommere pages display ? signs as ?)

 

thanks

 

 

brian

with ten thousand dollars we'll all be millionaires

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...