SQL Server: A Varchar column can hold up to 8000 characters, but a Text column allows up to 2 Gb. Articles would typically be stored as Text data type (if in the database). When dealing with Text (and/or ntext (unicode) and BLOB's) data type, there are some rules to observe. An MSDN search for 'BLOB and ADO' would go a long way towards providing the recommended reading.
HTH, Tore. -----Original Message----- From: Remie Bolte [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 9:24 AM To: ActiveServerPages Subject: Re: design issue I heard someone talking about maximum number of characters in SQL databases. is it true that a dbase has a character maximum or is there a type that holds unlimited text regards Remie Bolte ----- Original Message ----- From: "Bostrup, Tore" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Wednesday, September 04, 2002 3:11 PM Subject: RE: design issue > Both would be valid, reasonable options. Some people prefer to store the > path to a file in the database. This would allow manipulating the files > with any available tools, etc., but it also opens up for failure situations > (files moved, deleted, etc.). If you need strict control of the articles, > then store them in the database (your app can control what is done to them), > otherwise. Choose the approach that best fits your needs. > > HTH, > Tore. > > -----Original Message----- > From: Imad Jradi [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 04, 2002 8:58 AM > To: ActiveServerPages > Subject: design issue > > > I have articles that a user writes through a form in an asp and then submits > > it to the server. What would be the best solution/performance on storing > these articles. Do I store them in sql server as text or store them on the > hard disk as xml files with references in the database? > If anyone can help me with that, I would realy appreciate it. > Thanks > Imad > > > > _________________________________________________________________ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > %%email.unsub%% > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
