| Author |
Message |
SimonWilsher
Joined: 03 Aug 2005 Posts: 2
|
Posted: Tue Aug 09, 2005 5:19 pm Post subject: Currency symbol issues |
|
|
We have a varchar field in a Sybase ASA 9.0.2 database which correctly stores string data and includes the Pounds Stirling currency symbol, e.g.
Total Outstanding £150.00
However, when using a TSQLQuery in conjunction with the dbExpress driver for Sybase ASA, the following is returned when querying the string field:
Total Outstanding œ150.00
Can you advise what we can do to retain the £ currency symbol when running a query?
Simon Wilsher |
|
| Back to top |
|
 |
VISOCO Support VISOCO Software Support
Joined: 16 Jul 2002 Posts: 96
|
Posted: Wed Aug 10, 2005 11:07 am Post subject: |
|
|
Hello,
It looks like a character set conversion between server and client. The driver doesn't do any conversions at all. It completely rely on the client library.
What charsets are you using ? |
|
| Back to top |
|
 |
|