Does any one know how to solve this Problem

[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

 

But i have no problem using the $ symbol. the problem is only with the ? symbol. >_< >_<

 

thanking in advance.

 

 

 

mega

[hetster]

i had a similar error and did a quick dirty fix.

wether it will work for you i dont know.

 

i only plan on selling in uk so i changed all the USD to pounds and left the code as USD instead of GBP

 

now everything shows up as pounds and i then removed the currency selection box.

 

voilla instant uk ? and only the admin knows its USD and not ?

all paypal payments etc show as ?

[megnath]

No the problem is it does not takes the ? symbol in the colum symbol_left.

[Terra]

No the problem is it does not takes the ? symbol in the colum symbol_left.

A database encoding problem.

 

Try uploading the "?" sign again via your shop admin panel (Localisation -> Currencies) and see if that overrides it.

 

Terra

[megnath]

A database encoding problem.

 

Try uploading the "?" sign again via your shop admin panel (Localisation -> Currencies) and see if that overrides it.

 

Terra

 

 

no iam not able to update via data base it gives me error

[megnath]

If i try to change using admin i get 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'

 

And if i update using data base it updates but in the web site ? symbol apears in front of the ? symbol.

 

£699.00

 

Any one know how to solve this problem

 

But i have no problem using the $ symbol. the problem is only with the ? symbol.

 

thanking in advance.