OracleClient (.NET 1.1) : returned OracleDataReader values are truncated

P

panik

Hello,

I am currently trying out a connection with an oracle database. We're
using the .NET framework 1.1 and the oracle version is Oracle8i.

I am using the OracleClient provider (System.Data.OracleClient). Yet,
when returning a simple query (SELECT * FROM SomeTable), into an
OracleDataReader, some values get truncated.

This only happens with string colums (I guess, though I'm not 100%
sure). And it only happens on the values starting with the 2nd
instance/row of each unique value. And the values is truncated in half.

Eventually some results show illegal characters (squares in the HTML
code, then displayed as asian characters in the browser).

So I would get:


118433 Gondregnies
118434 Gondrç‘¥â³â€½æ˜¢æ±¡æ•³
118435 Gondre
118435 Gondre
13393132 Fouleng
13393132 Foul


This is a rather strange behavior.


Thanks for any insights,
v
 
C

Cowboy \(Gregory A. Beamer\)

What is the length of the field? In Oracle, you have LOBs for string types,
as well.

While this is not the problem, I prefer using the ODP.NET product (from
Oracle) over the MS ADO.NET bits. It is a free download from Oracle TechNet.

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************
Hello,

I am currently trying out a connection with an oracle database. We're
using the .NET framework 1.1 and the oracle version is Oracle8i.

I am using the OracleClient provider (System.Data.OracleClient). Yet,
when returning a simple query (SELECT * FROM SomeTable), into an
OracleDataReader, some values get truncated.

This only happens with string colums (I guess, though I'm not 100%
sure). And it only happens on the values starting with the 2nd
instance/row of each unique value. And the values is truncated in half.

Eventually some results show illegal characters (squares in the HTML
code, then displayed as asian characters in the browser).

So I would get:


118433 Gondregnies
118434 Gondr??????
118435 Gondre
118435 Gondre
13393132 Fouleng
13393132 Foul


This is a rather strange behavior.


Thanks for any insights,
v
 
P

panik

Hi,

We tried out the OPD from Oracle, but that gave some issues. I can't
recall which ones. The sysadmin that manages the machines (not ours, a
clients') tried installing the OPD, with the 10.x Oracle Client, but he
wasn't able to connect to the database (which is sitting on another
machine).

I'm currently trying to find a previous version of the ODP that could
eventually help me out. And am still looking around for a solution on
the Oracle Discussion forums.

I cannot exactly tell you what the length is of the field. The
documentation i base my work on (describing the View I query), says
'50'. I guess that must be 50 characters (or is it 50bytes).

i'm looking further into this myself. Yet, I'm pretty sure I'm not the
first one encountering this issue with the OracleClient provider.

cheers,
v
 
P

Paul Clement

¤ Hello,
¤
¤ I am currently trying out a connection with an oracle database. We're
¤ using the .NET framework 1.1 and the oracle version is Oracle8i.
¤
¤ I am using the OracleClient provider (System.Data.OracleClient). Yet,
¤ when returning a simple query (SELECT * FROM SomeTable), into an
¤ OracleDataReader, some values get truncated.
¤
¤ This only happens with string colums (I guess, though I'm not 100%
¤ sure). And it only happens on the values starting with the 2nd
¤ instance/row of each unique value. And the values is truncated in half.
¤
¤ Eventually some results show illegal characters (squares in the HTML
¤ code, then displayed as asian characters in the browser).
¤
¤ So I would get:
¤
¤
¤ 118433 Gondregnies
¤ 118434 Gondr??????
¤ 118435 Gondre
¤ 118435 Gondre
¤ 13393132 Fouleng
¤ 13393132 Foul
¤

If might help to identify the data types of the columns that hold this data.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Top