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