Oracle ODBC and long string fields

[splitthird]

I am connecting to Oracle 8.1. with CR9 Pro and CE9 Pro

The table in question has some fields that Crystal sees as Strings of length of 4000 characters. However I only get 255 characters displayed in my report. I have tried the Microsoft, Oracle and Crystal ODBC drivers as well as a Native Direct connection. I also tested the Microsoft ODBC from within Excel and got the same result (ie 255 chars).

There must be a way to see all the data surely? Please point me in the right direction.

Many thanks

 

[Turkbear]

Hi,
What is shown for that column when you do a Describe tablename command from SqlPlus ( If you can)?

Is the field set to can grow?

 

[splitthird]

You will laugh. I was working with two systems an existing system that was live and a replacement system that was in dev. The report was to be against the replacement system. To test the results I was looking up values in the live system and then running the appropriate report against the replacement system data. I was then finding the problem I described.
The answer was that the load of the replacement system from the live system was flawed and it had only loaded the first 255 chars for these large string fields.

thanks for responding Turkbear