January 31, 2009 at 4:36 am
hi,
I have one document with full of data how to store this document in database table column.
which datatype I can take to insert data in data table.
Thanks
Dastagiri.D
January 31, 2009 at 7:03 am
hey what i think is you have variable type of data in your document. you definately need to select proper data type for data. if you have numeric value then select numeric or int whatever suits you. but if you want character data type with support for unicode then you should opt for nvarchar data type.
Also if you are using sql server 2005 and if you can format your document to XML format then you can use XML data type which wud directly save your file into single column.
This is the best option for saving the data.
January 31, 2009 at 7:31 am
Can you provide some more details? Are you trying to store a document (word, pdf, etc...)? If you are attempting to store a document you need to use the varbinary datatype. You should do some research on storing blobs in SQL Server as it is usually not the best choice for large documents.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply