Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Long strings?
Message
From
26/05/2004 05:59:06
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00906915
Message ID:
00907233
Views:
11
>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

Dale,
When I first read your message, storing it in a memo + only the checksum in an indexed field came to mind. I see that Fabio already said that. Please read his message carefully.
PS: A key length is max 240 if collating is machine (otherwise half).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform