dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlDump Class / HexBlob Property

In This Topic
    HexBlob Property
    In This Topic
    Determines whether to dump BLOB columns using hexadecimal notation.
    Syntax
    'Declaration
     
    Public Property HexBlob As Boolean
    public bool HexBlob {get; set;}

    Property Value

    true, if BLOB columns should be added into dump text; otherwise, false. The default value is false.
    Remarks
    Hexadecimal notation is recoomended to use instead of text notation because it eliminates the encoding problems, which often occur when using Unicode or other multi-byte encodings. However in the hexadecimal notation one byte is represented by two hexadecimal digits, so the the dump script is larger than the script with the text notation dump. However, it is less than two times larger because when storing BLOB as a string in the script you need to escape the special characters, and this increases the dump size.
    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