Character code page problem i RB v7
We just bought a licence of ReportBuilder 7 in order to start replacing some
ancient QuickReport 1.1 stuff with something better. However, we have come
across a slight problem regarding the display of text from the database:
The database used is Sybase ASE 7. Here, data is stored in one of several
different "collation sequences", depending on which country the customer is
based in (Norway, Sweden, Denmark). This basically corresponds to the good
old MS-DOS code pages, meaning that characters above ascii 127 are shuffled
around a bit to make room for language-specific characters like umlauts and
accents and of course our Scandinavian ????? variants. Both the Delphi
data-aware components and the old Quick Report reports manage to display
this correctly on-screen.
When I cobble up a report in Report Builder 7 connected to the same dataset
however, these "high" characters are incorrectly represented in the
database-display fields. What should appear as "M?tteberg" appears as
"M>tteberg", "H?kon H?konsen" comes out as "H+kon H+konsen" (+ really being
the "dagger" character) and so on. A good old, classic, ANSI/ASCII
conversion snafu in other words. As I said, the very same dataset displays
correctly in the Delphi components.
How do I get around this? Any thoughts?
Regards,
Staale Sannerud
Bibliotekenes IT-senter AS
Oslo
ancient QuickReport 1.1 stuff with something better. However, we have come
across a slight problem regarding the display of text from the database:
The database used is Sybase ASE 7. Here, data is stored in one of several
different "collation sequences", depending on which country the customer is
based in (Norway, Sweden, Denmark). This basically corresponds to the good
old MS-DOS code pages, meaning that characters above ascii 127 are shuffled
around a bit to make room for language-specific characters like umlauts and
accents and of course our Scandinavian ????? variants. Both the Delphi
data-aware components and the old Quick Report reports manage to display
this correctly on-screen.
When I cobble up a report in Report Builder 7 connected to the same dataset
however, these "high" characters are incorrectly represented in the
database-display fields. What should appear as "M?tteberg" appears as
"M>tteberg", "H?kon H?konsen" comes out as "H+kon H+konsen" (+ really being
the "dagger" character) and so on. A good old, classic, ANSI/ASCII
conversion snafu in other words. As I said, the very same dataset displays
correctly in the Delphi components.
How do I get around this? Any thoughts?
Regards,
Staale Sannerud
Bibliotekenes IT-senter AS
Oslo
This discussion has been closed.
Comments
wanting to use? Send it to support@digital-metaphors.com
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com