Euro € symbol not recordable on a varchar field

Applications Forms
#1

Dear all,

I’ve created a very simple table for currencies.
currID int
currDesc varchar(50)
currAbbrev varchar(5)
currSymb varchar (1)

varchar are all latin1_swedish_ci (option)

when I try to insert “?” on Euro currSymb field the form seems to store it correctly.
But if I go later to next entry , i.e. US Dollar that work nice with $, and come back to Euro the “?” simbol has disappeared.
Have you please a workaround o a solution ?
many thanks
Giovannino

See mini video here : http://vimeo.com/37183922

#2

Re: Euro ? symbol not recordable on a varchar field

Dear all,

I don’t know if the solution is correct or not.
I found googling that “?” in database are stored as “€” . For me it’s misterious.
I changed the table to utf_unicode_ci and also the symbol field.
Then I enlarged the symbol varchar field width to 10 and then I’ve tried again to use the form to update the field value with “?”.
Ok when you store the first time ? it seems to work but when you try later to access to the form once again the value stored appears and it’s no good at all.

See picture attached (----)

On DB the value stored is “€” and now it’s also displayed .
It seems to me very complex.

Thanks
Giovanni

euro.png

#3

Re: Euro ? symbol not recordable on a varchar field

Support team said that’s a bug.
Bye
Giovannino