charset problem by OracleDictionary.FieldKinds

[Schlueter]

Hi,

I'm using a combination of TOracleDataSet, TDataSetProvider and TClientDataSet for showing data. But in some cases (e.g. join between 2 tables), string-fields from the non-updateable table will be shown as chinese characters instead of normal alphanumerics (a..z or 0..9). Normally I've set TOracleDataSet.OracleDictionary.FieldKinds = True. First when I set FieldKinds = False the string-fields will be shown correctly. Do You know why?

I've to say that this problem will only exists with TClientDataSet. If I will link the TDataSource direct to the TOracleDataSet it will be always shown correctly.

Because of charset-problems in ORACLE 11XE I've set TOracleSession.Preferences.ForceWideStrings = True.
The definitions of the string-fields on the database are with CHAR (e.g. VARCHAR(20 CHAR)).

Best regards
Rolf

Delphi XE10(Seattle) with DOA 4.1.3.5 on Win7, ORACLE 11gXE R2

 

[Marco Kalter]

If FieldKinds = True then then the non-updateable fields will become fkInternalCalc. This is the only difference. We'll try to reproduce this.