Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Long strings?
Message
From
25/05/2004 10:50:43
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00906915
Message ID:
00906928
Views:
24
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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform