SQLStringMBS.Compare(text as SQLStringMBS) as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Compares this string object with another string.

Function performs a case-sensitive comparison of the strings, and is not affected by locale.

Returns zero if the strings are identical, < 0 if this string object is less than text, or > 0 if this string object is greater than text.

See also:

• Compare(text as string) as Integer

SQLStringMBS.Compare(text as string) as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Compares this string object with another string.

Function performs a case-sensitive comparison of the strings, and is not affected by locale.

Returns zero if the strings are identical, < 0 if this string object is less than text, or > 0 if this string object is greater than text.

See also:

• Compare(text as SQLStringMBS) as Integer

SQLStringMBS.CompareNoCase(text as SQLStringMBS) as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Compares this string object with another string.

Function performs a case-insensitive comparison of the strings, and is not affected by locale.

Returns zero if the strings are identical (ignoring case), <0 if this string object is less than text (ignoring case), or >0 if this string object is greater than text (ignoring case).

See also:

• CompareNoCase(text as string) as Integer

SQLStringMBS.CompareNoCase(text as string) as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Compares this string object with another string.

Function performs a case-insensitive comparison of the strings, and is not affected by locale.

Returns zero if the strings are identical (ignoring case), <0 if this string object is less than text (ignoring case), or >0 if this string object is greater than text (ignoring case).

See also:

• CompareNoCase(text as SQLStringMBS) as Integer

SQLStringMBS.Constructor

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Creates a new empty string object.

See also:

• Constructor(Data as MemoryBlock)
• Constructor(Data as string, isText as Boolean = True)
• Constructor(other as SQLStringMBS)

SQLStringMBS.Constructor(Data as MemoryBlock)

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	SQL	MBS SQL Plugin	15.2	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Creates a new string object with data, e.g. for blob.

See also:

• Constructor
• Constructor(Data as string, isText as Boolean = True)
• Constructor(other as SQLStringMBS)

SQLStringMBS.Constructor(Data as string, isText as Boolean = True)

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Creates a new string object with data or text copied from the data string.

If isText is true, the data is interpreted as text and string encoding conversion may modify it. If isText is false the bytes are copied raw.

See also:

• Constructor
• Constructor(Data as MemoryBlock)
• Constructor(other as SQLStringMBS)

SQLStringMBS.Constructor(other as SQLStringMBS)

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Creates a new string object with data copied from the other string object.

See also:

• Constructor
• Constructor(Data as MemoryBlock)
• Constructor(Data as string, isText as Boolean = True)

SQLStringMBS.CopyBinaryData as string

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Copies the bytes from the internal buffer ignoring any text encoding.

SQLStringMBS.CopyMemoryBlock as MemoryBlock

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	SQL	MBS SQL Plugin	24.0	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Copies the content of the string/BLOB as MemoryBlock.

Some examples using this method:

• /SQL/SQL Unit Tests

SQLStringMBS.CopyText as string

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Copies the characters of this string as text.

Text encoding conversion may happen.