Re: which datatype do use for this?

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 07:53:02 -0400

Yes, if you choose image, the items are stored as blobs... They could be
word docs, excel spreadsheets, mp3s, images, gifs, jpegs.... whatever..The
only issue is is that the text manipulation functions do not work on image
as they do on text columns 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"djc" <noone@nowhere.com> wrote in message
news:e6pchyQvEHA.2568@TK2MSFTNGP11.phx.gbl...
> hmm... is this the datatype to be used if your application is to support
> user uploading of files? like an issue tracking system for instance that
you
> can 'attatch' files too.. like Word docs or spreadsheets? I would like to
> eventually create something like this.
>
> thanks!
>
>
> "Wayne Snyder" <wayne.nospam.snyder@mariner-usa.com> wrote in message
> news:uRPoWaOvEHA.4020@TK2MSFTNGP10.phx.gbl...
> > If you wish your article to include word documents, or images you might
> > consider the image data type.
> >
> > -- 
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "djc" <noone@nowhere.com> wrote in message
> > news:OrBvDFGvEHA.4028@TK2MSFTNGP15.phx.gbl...
> > > what datatype should be used for field that will store text data. To
get
> > an
> > > idea for length just picture your average MS KB Article... and longer.
I
> > > would need to store up to the rough equivelent of say 2 - 3 printed
> > pages...
> > > maybe 15000 characters?
> > >
> > > char(), varchar(), text?
> > >
> > > what to use? (i'm obviously not very experienced w/ sql server when it
> > comes
> > > to actual db table design)
> > >
> > > any help is appreciated. Thanks!
> > >
> > >
> >
> >
>
>
Loading