Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memos/Text and SQL-Server
Message
From
09/03/1998 16:34:00
 
 
To
03/03/1998 10:43:25
Steve Camsell
Windmill Associates
Bath, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00082290
Message ID:
00083493
Views:
30
>Thanks very much for responding. Using the Text datatype and allowing nulls sounds good to me, otherwise I could end up with overflows when I send my data back to the server. It was the mimimum 2K per record that I was really worried about.

I use a var255 field *and* a text field. The var 255 field catches most values, leaving the text field null so it doesn't use a 2k page. If the length of the data is > 255, I store the overflow in the Text field. I think this is the most efficient use of disk space, although it takes a little manipulation on your front end. Some people use 3 or 4 var255 fields instead of a text field.
Previous
Reply
Map
View

Click here to load this message in the networking platform