Save mix data in database

28 Oct 2007 5:43 AM

Husam

Hi EveryBody:

What is the data type that I have to use when I want to save mix data in
database for example photos,music,text fiel,doc file and movies ?

any help will be appreciated regard's

Husam

28 Oct 2007 4:06 PM

Morten Wennevik [C# MVP]

Hi Husam,

Use the 'image' datatype. Image is a binary datatype capable of holding up to 2Gb of data

On Sun, 28 Oct 2007 06:43:00 +0100, Husam <Hu***@discussions.microsoft.com> wrote:

Show quote

> Hi EveryBody:
>
> What is the data type that I have to use when I want to save mix data in
> database for example photos,music,text fiel,doc file and movies ?
>
> any help will be appreciated regard's
>
> Husam
>

--
Happy coding!
Morten Wennevik [C# MVP]

29 Oct 2007 5:18 PM

William Vaughn

None of the above should be stored in the database IMHO--not until SQL
Server 2008 that introduces the FileStream datatype. For reasons to lengthy
to list here, putting BLOBs in the database (no matter how well SQL Server
handles them) leads to too many other issues to justify their inclusion.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

Show quote

"Husam" <Hu***@discussions.microsoft.com> wrote in message
news:575A099F-03BE-4721-94B6-9476AE9DCD3F@microsoft.com...
> Hi EveryBody:
>
> What is the data type that I have to use when I want to save mix data in
> database for example photos,music,text fiel,doc file and movies ?
>
> any help will be appreciated regard's
>
> Husam