CLOB with net option error.

xalion · Post by **xalion** » Sun 22 May 2005 03:23

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.

Paul · Post by **Paul** » Mon 23 May 2005 13:40

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?

Guest · Post by **Guest** » Tue 24 May 2005 06:51

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.

Guest · Post by **Guest** » Sat 28 May 2005 01:51

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

Guest · Post by **Guest** » Sat 28 May 2005 02:08

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.

Devart Forums

CLOB with net option error.

CLOB with net option error.

:)

;)

:)