dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlBlob Class / Length Property
Example

Length Property (MySqlBlob)
Gets the size of the MySqlBlob.
Syntax
'Declaration
 
Public Overrides ReadOnly Property Length As Long
 

Property Value

The size of the MySqlBlob in bytes.
Remarks
The size of the MySqlBlob is always returned in bytes for all data types.
Example
MySqlDataReader pictureReader = myCommand.ExecuteReader();
pictureReader.Read();
MySqlBlob pictureBlob = pictureReader.GetMySqlBlob(pictureReader.GetOrdinal("Picture"));
if (pictureBlob.Length > 100)
  pictureBlob.SetLength(100);
Dim pictureReader As MySqlDataReader = myCommand.ExecuteReader
pictureReader.Read()
Dim pictureBlob As MySqlBlob = pictureReader.GetMySqlBlob(pictureReader.GetOrdinal("Picture"))
If (pictureBlob.Length > 100) Then
  pictureBlob.SetLength(CLng(100))
End If
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also