SQL Server存储BLOB（国外英文资料）.doc

SQL Server存储BLOB（国外英文资料） What is a BLOB First, lets compare two types of file types, ASCII and binary. Most data values stored in SQL Server are made up of ASCII (U.S. information exchange standard code) characters. In short, ASCII characters are letters, Numbers, and symbols that can be found on a computer keyboard. We can make changes to files that contain only ASCII characters in the text editor, such as notepad, and will not cause any damage to the file. The binary file contains not only ASCII characters but also special control characters and byte combinations on the keyboard. If you use notepad to open an MP3 file, and delete some of the characters in an attempt to make the song short and is likely to destroy the entire file, cause the MP3 cant normal play, this is because the notepad can only be used to edit the ASCII characters, and unable to properly interpret or create a binary. Other binary data includes images and executable assembly programs. A BLOB is, by definition, a large binary file. Why do you store blobs in SQL Server Some people like to store binary objects in SQL server databases, and there are people who object to doing so. We should be considerate in both ways. For example, lets say that we are a database administrator in a typical sales enterprise. The enterprises usually have a lot of product for sale, contains different categories of products, product line and below the level is the individual products or components, we call them artifacts. For each artifact, a standard detailed inventory list is provided, such as price, cost, existing quantity, vendor, and so on. In addition, many components could be used to describe the component sales manual or brochure, they are often brochures in PDF, slide or some type of image appears in the form of electronic document, etc. One way to handle these electronic documents is to put them all into a file server and create a directory for each component. This may work at first, but when customers or empl