Understanding BLOBs
Most of the values stored in SQL Server consist of ASCII (American Standard Code for Information Interchange) characters. A basic explanation of ASCII characters is that they are the letters, numbers, and symbols found on the keyboard. A text editor such as Notepad can alter a file holding only ASCII characters without any consequences. However, data is not limited to strings and numbers; it is always a common requirement to store a large amount of binary data in a SQL Server table along with other ASCII data; Word documents, XML documents, and images are some examples. Binary files contain ASCII characters, special control characters, and byte combinations not found on the keyboard. Opening a Microsoft Word document inside ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access