Data type question

I just had some one ask me about storing PDF files in a SQL table. My
question is, what would the data type be for that column? Is the data type
TEXT the correct one for this?
Thanks to all who can help me.
Billy
"BillyDees" <BillyDees@.discussions.microsoft.com> wrote in message
news:F2F96802-6D94-49EC-9720-D7B16C733CBC@.microsoft.com...
>I just had some one ask me about storing PDF files in a SQL table. My
> question is, what would the data type be for that column? Is the data type
> TEXT the correct one for this?
No, PDF is a binary format. Store it in an IMAGE (SQL 2000) or
varbinary(max) (SQL 2005).
David
|||Thanks David. I was just talking with a couple co-worker this morning and
they where saying the same thing.
Billy
"David Browne" wrote:

> "BillyDees" <BillyDees@.discussions.microsoft.com> wrote in message
> news:F2F96802-6D94-49EC-9720-D7B16C733CBC@.microsoft.com...
>
> No, PDF is a binary format. Store it in an IMAGE (SQL 2000) or
> varbinary(max) (SQL 2005).
> David
>
>