Actually, the field is not a varchar2(2000), but a LONG. Why would the
LONG field be behaving differently from Oracle 8 to Oracle 9?
Sybrand Bakker wrote:
> On 11 Apr 2005 11:25:33 -0700, "Sean" <seanm555_at_comcast.net> wrote:
>
> >Hello all...
> >
> >We just upgraded our systems from 8.1.7 to 9.2.0.4. A particular
> >varchar2(2000) column is giving me problems:
> >
> >Using sqlplus I can read the column (Has data like 'This is test
data')
> >
> >Using Oracle 9.2.0.4 client driver and Microsoft ADO 2.1, I only get
> >the first character in the column (like 'T').
> >
> >Doing a concat to surround the result with '***', I get '***This is
> >test data***' from sqlplus and get '***T' from the oracle client
with
> >the same statement. What could possibly be happening? Any ideas?
> >Thanks,
> >
> >Sean
>
> If you don't have issues on a client PC with good ol plain sql*plus,
> it's Microsoft ADO. Apart from that 9.2.0.4 is not exactly the most
> recent version, and the ADO driver may be simply incompatible with
9i.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Mon Apr 11 2005 - 18:37:04 CDT
