BorlandTalk.com

Christian Kaufmann · Guest

Hi,

I have an application with D6, dbExpress Components, Upscene Driver
and Firebird 1.5. Normally I use varchar columns with the character
set ISO8859_1, but in one or two tables I need some columns with
unicode characters.

I declared them as VARCHAR(40) CHARACTER SET UNICODE_FSS.

My question is, if I can access these columns correctly with dbExpress
and how to do that? I want to load one record in a TClientDataSet,
change it and then save it again?

Is this possible with dbx/D6?

If not, will it be possible with dbx/D9?

If not, what is the best alternative to connect D6 to Firebird 1.5
with unicode support?

cu Christian

Chris Hedges · Guest

Hi Christian,

for Unicode support in Delphi 6 I would recommend using the TNT unicode
controls as these are the only way I know of getting around some
on the non-Unicode VCL issues (Unicode data will not display in the normal
VCL controls).

when using Tables etc, replace the TStringFields with the TntStringField as
these will do the conversion from the Firebird's UTF8 into Widestrings
which you will be able to display :)

As for using .Net version of Delphi, I'm currently having a few problems of
my own with Unicode, so I'm not much help on that at the moment,
but I'm sure someone will show me the light!!!

Thanks

Christaan Hedges

"Christian Kaufmann" <christian.kaufmann (AT) gmx (DOT) net> wrote