Getting around max Text Field Size

by Joshua Wine » Wed, 24 Jul 2002 04:07:42

I'm fairly sure I already know the answer to this question, but I
thought it would hurt to ask anyway.

Is there a way to get around the size limit of 64,000 characters in a
text field? I have a database that controls a Adobe Acrobat document via
AppleScript, but I would like to still be able to search for text in the
Database rather than in Acrobat, but some of the OCR text could be over
64,000 characters, and unfortunately it would have to be all the text,
or none at all.

Thanks.

--Joshua.

Top

1. Varchar or Text fields and Max Row Size

I searched Google and found some suggestions, but nothing
that directly answered my question. What is your opinion of
this scenario:

I'm designing a table that will contain the answers to about
25 multi-part questions. It's going to require about 55 fields
in the Answers table and about 15 of them are for Comments.
If I use VARCHAR(1000) fields for Comments, that will use
up 1.5 k of my 2 k page, leaving little room for the other 40
fields.

If I use TEXT fields, will that not free up the row space?

How might that affect searches on those fields, if someone
wanted to look for answers with specific notes in comment
fields?

Would it make a difference to know that there will be few
records? (less than 1000 records per year)

Thanks in advance for your insights. I look forward to
seeing what kind of feedback comes out of this.
--
Danny J. Lesandrini

2. data for 6 million of china enterpises and institutions

3. Any work around for max row size of 1962

4. ADODC2.refresh

5. Max database size vs max data file size

6. looking for ...

7. Getting around invalid Field Names

8. Installing SQL Server CE 1.1

9. Using Text fields to get around Max Row Size?