C H A P T E R  17

Working with Text and Binary Data

Some kinds of data have special formats, are very large, or vary greatly in size. Here, I’ll show you techniques for working with text and binary data. In this chapter, I’ll cover the following:

  • Understanding SQL Server text and binary data types
  • Storing images in a database
  • Retrieving images from a database
  • Working with text data

I’ll also present the T-SQL for creating tables in the tempdb database, which is intended to hold any temporary table. I’ll start by covering what data types support these kinds of data.

Understanding SQL Server Text and Binary Data Types

SQL Server provides the types CHAR, NCHAR, VARCHAR, NVARCHAR, BINARY, and VARBINARY for working with reasonably small text ...

Get Beginning C# 5.0 Databases, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.