Error in Oracle 10g XE on TStringField

[Zugg]

Hello,

In my application developped in Delphi 2009, using DOA 4.1.2.0, I have an error in TOracleDataSet, TStringField are not correct, error indicates me that this fields must be TWideStringField instead of TStringField.

All works perfectly in Oracle 10g (not express edition) with TStringField.

Why TOracleDataSet not works in Oracle 10g XE with TStringField but works in Oracle 10g ?

Could you tell me a solution with this problem.

Thanks.

--
Zugg

 

[Marco Kalter]

Perhaps the character sets of the 2 databases are different? E.g. one is an UTF8 database and the other uses a standard national character set?

You can use the TOracleSession.Preferences.ForceWideStrignFields property to force TWideStringFields on all databases.

 

[Zugg]

Thanks for your answer.

If I use the TOracleSession.Preferences.ForceWideStrignFields property to force TWideStringFields on all databases, it means that I must change all my TStringField to TWideStringField ?
But if I do this change, my application will work both on Oracle 10g XE (with UTF8 character set) and on Oracle 10g standard edition (with WE8MSWIN1251 character set) ?

--
Zugg

 

[Marco Kalter]

That is correct.