DBMONEY extensions
You can specify the currency symbol and decimal-separator symbol with the DBMONEY environment variable. These settings override any currency notation that the client locale specifies.
You can use multibyte characters for these symbols if
your client code set supports them. For example, the following table
shows how multibyte characters appear in examples of output.
| Format string | Number to format | DBMONEY | Output |
|---|---|---|---|
| "$$,$$$.$$" | 1234 | '$'. | $1,234.00 |
| "$$,$$$.$$" | 1234 | DM, | DM1.234,00 |
| "$$,$$$.$$" | 1234 | A1A2. | A1A21,234.00 |
| "$$,$$$.$$" | 1234 | .A1A2 | s1,234.00 |
| "&&,&&&.&&@" | 1234 | .A1A2 | s1,234.00A1A2 |
| "$&&,&&&.&&@" | 1234 | A1A2. | A1A2s1,234.00 |
| "$&&,&&&.&&@" | 1234 | .A1A2 | s1,234.00A1A2 |
| "@&&,&&&.&&" | 1234 | .A1A2 | A1A2s1,234.00 |
In the preceding table, the character s represents
a blank or space.