There seem to be serious technical difficulties, indeed.
Why would you need an index on so long a string, in the first place? (Perhaps if I know the answer to this, we can think about a different approach...)
>I have to store a string that is 1024 bytes (1K) in size. I would love it store them in a table and index them, but the only way I can think to do this is store the string in chunks of 254 bytes. Then I would have to put them back together in order to get the orginal string. Plus I have a problem creating that long of index.
>
>I know I can store them in memo fields, but those do no tend real well to indexing. I thought about memo binary, but the same problem. I thought about general, but ran into same types of issues. I know I can store a pointer to a text file and read them out of there, but no real way to index these.
>
>Does anyone have an idea I am overlooking? Is there a better way of storing and indexing these strings?
>
>Thanks,
>Dale
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)