Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> select statement returns only the first character...
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