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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
