Hello all, I have a question regarding datatype (SQL 2000).
I need to store a large amount of data (text) for multiple users. Here are the details The text may vary in size from NULL - 32,000 chars. The actual text never needs to be seatched (entire field is loaded based on user_ID), so no need for index -- (I assume) The text needs to be loaded all at once (and will be accessed frequently) As mentioned earlier, there will be multiple users, each with up to 32,000 chars of text. The only two ways I can think of to store this data are: Text Field -- store all text in one field with a datatype of 'text' and load the entire field every time it is needed VARCHAR(8000) field -- when the data is entered, break it in to 8000 char chunks. and store in database with user_ID and chunk (and posible tinyint to store the chunk #). Then, when needed, load and attach all chunks for the specified user_ID. Which of these ways (or any other ways that I haven't mentioned) is the best. Thanks, Andy __________________________________________________ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
