1.1 number

SMALLINT(99)
BIGINT(99)
VARCHAR(99)
TEXT
DATE(30)

1.2 blobs

• Client sends a file to server, server encodes file to base64 and store as Blob
• Client read a blob, server send base64 to client

Generally one should not use blob to store large files because the load times are big and takes alot of bandwidth. If many people are reading large images on clientside, they will load very slowly.