O'Reilly logo

Beginning C# 5.0 Databases, Second Edition by Vidya Vrat Agarwal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required