Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Euro ? and Sterling ? symbols show up as ?


ultan

Recommended Posts

IS there a reason why the euro ? and pound sterling ? symbols show up as ?

The US dollar shows up as $ as expected

 

Any ideas?

 

This is on the site itself not mails as i saw some others having problems with emails and the symbols of the currency

Link to comment
Share on other sites

this is in the database in the currencies table

 

SQL to input currencies info:

 

 

LOCK TABLES `currencies` WRITE;

INSERT INTO `currencies` VALUES (1,'US Dollar','USD','$','','.',',','2',1.00000000,'2004-04-05 08:33:22'),(2,'Euro','EUR','','EUR','.',',','2',0.82529998,'2004-04-05 08:33:24'),(3,'British Pound','GBP','£','','.',',','2',0.54670000,'2004-04-05 08:33:25');

UNLOCK TABLES;

Link to comment
Share on other sites

this is in the database in the currencies table

 

SQL to input currencies info:

LOCK TABLES `currencies` WRITE;

INSERT INTO `currencies` VALUES (1,'US Dollar','USD','$','','.',',','2',1.00000000,'2004-04-05 08:33:22'),(2,'Euro','EUR','','EUR','.',',','2',0.82529998,'2004-04-05 08:33:24'),(3,'British Pound','GBP','£','','.',',','2',0.54670000,'2004-04-05 08:33:25');

UNLOCK TABLES;

 

 

OK cheers.

 

I have sorted the ? symbol.

 

Instead of putting ? in the database one has to put £.

 

But for the € it doesnt come up at all.

I know I have EUR on the righthand side but id much prefer the € Is there an equivilant for the above that will displat the euro symbol?

Link to comment
Share on other sites

SQL to input currencies info:
LOCK TABLES `currencies` WRITE;
INSERT INTO `currencies` VALUES (1,'US Dollar','USD','$','','.',',','2',1.00000000,'2004-04-05 08:33:22'),(2,'Euro','EUR','?','EUR','.',',','2',0.82529998,'2004-04-05 08:33:24'),(3,'British Pound','GBP','?','','.',',','2',0.54670000,'2004-04-05 08:33:25');
UNLOCK TABLES;

Link to comment
Share on other sites

DROP TABLE IF EXISTS currencies;

CREATE TABLE currencies (

currencies_id int NOT NULL auto_increment,

title varchar(32) NOT NULL,

code char(3) NOT NULL,

symbol_left varchar(12),

symbol_right varchar(12),

decimal_point char(1),

thousands_point char(1),

decimal_places char(1),

value float(13,8),

last_updated datetime NULL,

PRIMARY KEY (currencies_id)

);

 

INSERT INTO `currencies` VALUES (1,'US Dollar','USD','$','','.',',','2',1.00000000,'2004-04-05 08:33:22');

INSERT INTO `currencies` VALUES (2,'Euro','EUR','?','EUR','.',',','2',0.82529998,'2004-04-05 08:33:24');

INSERT INTO `currencies` VALUES (3,'British Pound','GBP','?','','.',',','2',0.54670000,'2004-04-05 08:33:25');

Link to comment
Share on other sites

DROP TABLE IF EXISTS currencies;

CREATE TABLE currencies (

currencies_id int NOT NULL auto_increment,

title varchar(32) NOT NULL,

code char(3) NOT NULL,

symbol_left varchar(12),

symbol_right varchar(12),

decimal_point char(1),

thousands_point char(1),

decimal_places char(1),

value float(13,8),

last_updated datetime NULL,

PRIMARY KEY (currencies_id)

);

 

INSERT INTO `currencies` VALUES (1,'US Dollar','USD','$','','.',',','2',1.00000000,'2004-04-05 08:33:22');

INSERT INTO `currencies` VALUES (2,'Euro','EUR','€','EUR','.',',','2',0.82529998,'2004-04-05 08:33:24');

INSERT INTO `currencies` VALUES (3,'British Pound','GBP','?','','.',',','2',0.54670000,'2004-04-05 08:33:25');

 

 

Cheers but as I said I tried all this but a ? keeps coming up instead of the euro symbol.

I have STS installed if that might be of interest..

 

EDIT Yea it seems to be something with STS as it tried it there on another store and the symbol is fine. Must be using a different unicode or ascii

Link to comment
Share on other sites

Can you not make the Euro symbol change via your stores control panel?

 

Tried that.

 

let me clarify that the actual output is this � rather then this ?

 

Something seems a bit weird there.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...