Merry Christmas everyone and a Happy New Year! ----- Original Message ----- From: "Bostrup, Tore" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Friday, September 13, 2002 11:12 PM Subject: RE: design issue
: WOW - i. only posted this 9 days ago... (and received it this AM). : : Tore. : : -----Original Message----- : From: Bostrup, Tore [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, September 04, 2002 9:24 AM : To: ActiveServerPages : Subject: RE: design issue : : : 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.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]
