VarBinary vs Image SQL Server Data Type to Store Binary Data?

by

Since image is deprecated, you should use varbinary.

per Microsoft (thanks for the link @Christopher)

ntext , text, and image data types will be removed in a future
version of Microsoft SQL Server. Avoid using these data types in new
development work, and plan to modify applications that currently use
them. Use nvarchar(max), varchar(max), and varbinary(max) instead.

Fixed and variable-length data types for storing large non-Unicode and
Unicode character and binary data. Unicode data uses the UNICODE UCS-2
character set.

More Related Contents:

  1. Subquery in select not working in SQL Server
  2. Storing images in SQL Server?
  3. How to create jobs in SQL Server Express edition
  4. How to delete large data of table in SQL without log?
  5. Limitations of SQL Server Express
  6. What is the best way to truncate a date in SQL Server?
  7. Dynamic SQL (passing table name as parameter)
  8. What is a Trusted Connection?
  9. Understanding SQL Server LOCKS on SELECT queries
  10. How to determine total number of open/active connections in ms sql server 2005
  11. Handling date in SQL Server
  12. Tablix: Repeat header rows on each page not working – Report Builder 3.0
  13. ORDER BY DATE showing NULLS first then most recent dates
  14. How do you change the datatype of a column in SQL Server?
  15. TABLOCK vs TABLOCKX
  16. How to convert number of minutes to hh:mm format in TSQL?
  17. What happens if you don’t commit a transaction to a database (say, SQL Server)?
  18. Dynamically assign filename to excel connection string
  19. SQL Server Group by Count of DateTime Per Hour?
  20. Temporarily disable all foreign key constraints
  21. How to import a DBF file in SQL Server
  22. SQL Server Dependencies
  23. SQL Server Passthrough query as basis for a DAO recordset in Access
  24. T-SQL query to show table definition?
  25. Why do I get the error “Xml data type is not supported in distributed queries” when querying a linked server for non-xml data?
  26. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  27. Date range overlapping check constraint
  28. SQL Server 2008 can’t login with newly created user
  29. Update SQL with consecutive numbering
  30. Nested transactions in Sql Server

Leave a Comment