Pls Can any one help

[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]

Hi

 

Go back into your Admin/Currencies ... Add Currency. Use "Sterling" as name then "GBP" as code and "Symbol Left", you can leave all else as is except to make it "Default"

 

It worked for me.

 

 

John Jones