• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 714
  • Last Modified:

What data type to save a pdf / word file in SQL Server 2008 Express Edition?

Hi, what data type is needed  to save a text files , pdf , word file in SQL Server 2008 Express Edition?
0
0nepiece
Asked:
0nepiece
1 Solution
 
0nepieceAuthor Commented:
particularly Electronic Signature files
0
 
zadeveloperCommented:
Use Image.
I found this to be best as some files that are saved are Binary ... which get messed up using a "string" field like nvarchar, text etc...
0
 
sameer2010Commented:
Use varbinary(MAX). This would also help you create index and search the contents of the PDFs, if need be.
0
 
grvmohanCommented:
Using "image" data type u can save any file into database. Take the file into byte[] array and pass this array as parameter for file data.
0
 
0nepieceAuthor Commented:
Thanks!
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now