Storing large text fields ---- urgent help required.

From: CME <support_at_cmesys.demon.co.uk>
Date: Tue, 4 Sep 2001 17:01:42 +0100
Message-ID: <999619263.17154.0.nnrp-13.c2de4217@news.demon.co.uk>

Dear all,

Sorry for this question, but I need to release in the next week.

We have an internally developed reportwriter that stores its reports as XML in a database. Historically this data was stored in a column of type LONG.

The average length of characters is about 100,000.

We cannot write this amount of text to the field even when trying to BIND the field.

I have also tried a CLOB, but VB does not support this datatype via ADO..

So if anyone could tell me how the hell I am ameant to store this data (and initially populating the table with our default reports), I would be very happy.

I have never had any problems using Sybase or SQL Server, but I have been round in circles for the last two days.

Information:

We are using Oracle 8i standard edition with ADO 2.6 to VB 6 (sp 5).

An example of the SQL would be useful.

Matt. Received on Tue Sep 04 2001 - 11:01:42 CDT