Page 1 of 1
How can I save the currency symbol into DB
Posted: Fri Dec 05, 2025 12:19 pm
by unixkd
Hi all and happy weekend.
How can I save ANY currency symbol into a table in database. I notice that:
Function getcurrency()
Local getlist[0], cCurr := space(4)
@ 1,1 dcsay "enter currency symbol" get cCurr
Dcread GUI modal addbuttons
When I enter pound or some other symbol and the get get lost focus the text box change to ?
Thanks
Joe
Re: How can I save the currency symbol into DB
Posted: Mon Dec 08, 2025 5:44 pm
by rdonnay
I need more information. I don't see a problem.
Re: How can I save the currency symbol into DB
Posted: Tue Dec 09, 2025 8:22 am
by unixkd
Hi Roger
I have a setup table with 3 fields namely:
1. Currcode e.g. NGN for Nigeria naira
2. CurrName e.g Naira
3. CurrSymbol e.g N crossed with equal sign.
Now where the problem lies is the symbol. If copy the symbol from charmap.exe of windows and paste it on the dcsay.. get cVarSymbol, the text box change to ? when the text box loses focus. This problem is easy to test. Just run charmap.exe and copy even the eur currency symbol into any get object in your application then press enter key it will change to ? I think it has to do with unicode handling by Xbase++ which deal with ansi. I don't know how DBMS
like ads handle unicodes or problem like this.
Thanks
Joe
Re: How can I save the currency symbol into DB
Posted: Sun Dec 14, 2025 7:04 am
by Auge_Ohr
hi,
which Font do you use ?
Alaska support :
Arial Arial
Arial Fett
Arial Fett Kursiv
Arial Kursiv
Arial Narrow Arial Narrow
Arial Narrow Kursiv
Arial Narrow Fett
Arial Narrow Fett Kursiv
Courier New Courier New
Courier New Fett
Courier New Fett Kursiv
Courier New Kursiv
Verdana Verdana
Verdana Fett
Verdana Kursiv
Verdana Fett Kursiv
your Sign must include in those Fonts else you Will get "?" for unknown Sign.