Devart Forums

delphi 7+ODAC 5.5.1.18+oracle 9.2.0.6+chinese winxp sp2
table:
create table NEWS
(
ID NUMBER(10) not null,
TITLE VARCHAR2(100) not null,
INDATE DATE,
NOTE CLOB,
AUTHOR VARCHAR2(40)
)

when I use OCI and select * from NEWS ,the NOTE field return all .
but when I use NET option ,The NOTE field returns random length
of the field. So I can't use net option with CLOB.
Please check.

What is a value of TOraSession.Options.Charset,
TOraSession.Options.UseUnicode, TOraSession.Options.CharLength?
What is a charset of Oracle server? What kind of data do you store in CLOB
(English text, national text)? Do you receive a CLOB data truncated or you
see wrong value in OraQuery1.GetLob('CLOBFIELD').LengthLob?

TOraSession.Options.Charset is null , default as connected.
TOraSession.Options.UseUnicode is false
TOraSession.Options.CharLength is 1
What is a charset of Oracle server? ZHS16GBK
national text
I receive a CLOB data truncated ,not fixed length,but random.

query.GetLob('NOTE').LengthLob isn't right also.

hi.
I find out the problem.but I can't corroct because I haven't NET source.
The reason is: my clob include chinese and english. '中文 english'
so the length of clob is widestring's length. not the field's real bytes length.

and ODAC fetch only part of clob field.

Can you correct this problem?
Thanks.