|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Save mix data in databaseHi 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 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] 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. -- Show quote____________________________________ 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) ----------------------------------------------------------------------------------------------------------------------- "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 |
|||||||||||||||||||||||