Unusual Currency Symbol

[megnath]

I there Iam trying input Pound as my currency using the admin.

I get a followling error.

 

1406 - Data too long for column 'symbol_left' at row 1

 

update currencies set title = 'GBR POUND', code = 'GBR', symbol_left = '?', symbol_right = '', decimal_point = '.', thousands_point = ',', decimal_places = '2', value = '1.00000000' where currencies_id = '2'

 

 

I tryed doing through update state ment using mysql.

as followling...

 

UPDATE currencies SET symbol_left = '?' WHERE currencies_id = '2'

 

Then it changed the data in the database.

 

But in the website it shows as followling

 

£699.00

 

? this Symbol appears in front of the ? sign.

 

 

Any one know how to solve this problem

 

thanking in advance.

 

mega

[Guest]

I too am having problems with the currency symbols.

 

I use the ? symbol, but where ever I put the ? symbol, it shows a J instead. I tried the modifications as suggested above but all I got was J J instead of J.

 

If I use the $ symbol, everything is fine.

 

Anyone got any ideas?

[queenie]

Mike

 

Did you resolve this problem I am having the same issue, but I get an '?' instead of the pound '?' symbol. Also I get some strange values showing.

 

Oddly on the 'Home' page it shows $ no matter what I do.