« on: November 26, 2009, 06:35:23 am »
On the server side, you look for the name and value pair. It also depends on whether this is a POST or GET operation. GET,the name value pairs are visible in a URL, POST the name value pairs are sent directly to the server.
BLOBS are for data that haven't a character structure, just like documents created in Office, or images.
CLOBS are just the opposite, great for information that is based on characters, like an XML file, or a long, long, long string.
When you try to retrieve the information from the database CLOBS can be readed directly into a variable, and you can"view" the content pretty easy. For BLOBS the things get complicated,because the whole content most be readed/writed at once, and to view the content you must interpret what it is, say if it's a Excel document you most readed asan Excel book, and so on for each kind of information you store in the column.