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