Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> select statement returns only the first character...

select statement returns only the first character...

From: Sean <seanm555_at_comcast.net>
Date: 11 Apr 2005 11:25:33 -0700
Message-ID: <1113243933.686422.216220@l41g2000cwc.googlegroups.com>


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 Received on Mon Apr 11 2005 - 13:25:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US