SQLValueMBS.setAsUShort(value as UInt16)

Sets value as unsigned short data.

SQLValueMBS.setAsValueRead(value as SQLValueReadMBS)

This method allows using SQLField or SQLParam object received from one SQL statement as a parameter for another SQL statement.

SQLValueMBS.setVariant(value as Variant)

dim con as SQLConnectionMBS // your connection
dim pic as picture // some picture

// get picture data
dim jpegData as MemoryBlock = pic.GetData(Picture.FormatJPEG, 80)

// get a command for an Insert command
dim sql as string = "Insert into BlobTest(name, image) values (:name, :image)"
dim cmd as new SQLCommandMBS(con, sql)

// set values by variant
cmd.Param("name").setVariant "logo.jpg"
cmd.Param("image").setVariant jpegData

// do the insert
cmd.Execute

MemoryBlock and Strings without text encoding are converted to byte values (BLOB).
Texts and Strings with encoding are converted to text values.
Raises exceptions if you pass anything which is not recognized.
Other types are translated as good as possible.

With version 19.0 or later, you can pass folderitem to stream blob from file. This may raise exception if file can't be opened.