Euro ? and Sterling ? symbols show up as ?

[ultan]

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

[pyramids]

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;

[ultan]

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?

[Guest]

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;

[Guest]

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');

[ultan]

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

[Guest]

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

[ultan]

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.

[Guest]

When you browse the database with something like PHPmyAdmin, under the Table currencies, what does it show for the Euro Symbol there?

[ultan]

Tried that.

 

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

 

Something seems a bit weird there.

 

This seems to be a replacement character.

[ultan]

When you browse the database with something like PHPmyAdmin, under the Table currencies, what does it show for the Euro Symbol there?

 

Yep as with the $.

[ultan]

When you browse the database with something like PHPmyAdmin, under the Table currencies, what does it show for the Euro Symbol there?

 

Yep as with the $.

[ultan]

Yep as with the $.

 

 

Got it.

 

I put in the HTML decmial coding for it

 

http://www.fileformat.info/info/unicode/char/20ac/index.htm

 

Cheers for the help guys. Hope someone uses this in the future.