brianstorm Posted November 1, 2006 Posted November 1, 2006 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
insomniac2 Posted November 1, 2006 Posted November 1, 2006 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.
insomniac2 Posted November 1, 2006 Posted November 1, 2006 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.
brianstorm Posted November 3, 2006 Author Posted November 3, 2006 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.