Re: sql server 2005 express database design

  • From: "Richard Thomas" <rthomas@xxxxxxxxxxx>
  • To: <programmingblind@xxxxxxxxxxxxx>
  • Date: Fri, 26 Oct 2007 19:02:23 -0400

Well, there are at least two forms of storage to hold textual data.  One is 
VarChar and the other is a Big Field which actually holds a pointer to the 
large stored text field if I remember.
I'm not sure about storing those types of objects other than as these in the 
DataBase but you could store them as text objects and make sure to restore them 
as the correct object type by having a code denoting what type was stored in 
the text field.
I'm not sure about other methods of converting them into DataBase format and 
then back again.
If there are better methods someone more experienced will, hopefully, correct 
me if I'm wrong.

  ----- Original Message ----- 
  From: Andy B 
  To: programmingblind@xxxxxxxxxxxxx 
  Sent: Friday, October 26, 2007 11:44 AM
  Subject: sql server 2005 express database design

  I need to write a program that references, categorizes, indexes and allows 
searches (including full text searches) on data inserted into the database. 
Different data formats like Word, rtf, txt, html and other sources would have 
to be put into the database. Is it easier/better to insert the files themselves 
(i.e. insert the actual word file) or just the text+formatting of the word 
file? Any ideas how to do this stuff or where I can find out more?

Other related posts: