Getting NVARCHAR2 columns in TOracleDataset

[plpolak]

I have a table that is defined as:
CREATE TABLE TEST_TABLE (
ANSI_TEXT VARCHAR2(250)
,WIDE_TEST NVARCHAR2(250)
);

Server is configured to use WE8MSWIN1252 character set and AL16UTF16 NCHAR character set. Server version is 9.2.0.1 on Linux.

I setup a connection to the server with TOracleSession.BytesPerCharacter := bcAutodetect. A TOracleDataset uses this session and retrieves all records. However the NVARCHAR2 field is also returned as a TStringField in the dataset, and thus I loose the Unicode strings from the database (they are converted to Ansi).

I use Delphi 7.1 with DOA 4.0.6.2, and I experience this both when I debug the fields generated by DOA, and when I try to create a DBGrid on the dataset (using TNT DBGrid, that supports Unicode).

Any clue what is wrong here?

thanks.

Pieter Polak

 

[plpolak]

Can this be solved? I need this kind of support in my application, but it seems that DOA cannot handle it. Any plans in the future?

 

[Marco Kalter]

The TOracleDataSet only supports TStringFields, so you will always get character data as AnsiStrings.

 

[plpolak]

Any plans for support in future versions? Would be nice!!

Pieter

 

[Marco Kalter]

It's on our to-do list.

 

[plpolak]

Any timeframe when we can expect this? DOA is really a nice tool to work with in Delphi, but we need this functionality in our apps.

Pieter

 

[Marco Kalter]

I currently do not have a date for this.