SQLStringMBS.Compare(text as SQLStringMBS) as Integer

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

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

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

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

See also:

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

SQLStringMBS.Constructor(Data as MemoryBlock)

See also:

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

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

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)

See also:

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

SQLStringMBS.CopyBinaryData as string

SQLStringMBS.CopyMemoryBlock as MemoryBlock

Some examples using this method:

• /SQL/SQL Unit Tests

SQLStringMBS.CopyText as string

Text encoding conversion may happen.

SQLStringMBS.Empty

SQLStringMBS.GetBinaryLength as UInt32   Deprecated

Deprecated. Please use BinaryLength property.

SQLStringMBS.GetLength as UInt32   Deprecated

Deprecated. Please use Length property.
For multibyte character sets, GetLength counts each 8-bit character; that is, a lead and trail byte in one multibyte character are counted as two bytes.

SQLStringMBS.Left(count as Integer) as SQLStringMBS

SQLStringMBS.MakeLower

Some examples using this method:

• /SQL/SQL Unit Tests

SQLStringMBS.MakeUpper

Some examples using this method:

• /SQL/SQL Unit Tests

SQLStringMBS.Mid(first as Integer) as SQLStringMBS

first: The zero-based index of the first character in this string object that is to be included in the extracted substring.

See also:

• Mid(first as Integer, Count as Integer) as SQLStringMBS

SQLStringMBS.Mid(first as Integer, Count as Integer) as SQLStringMBS

first: The zero-based index of the first character in this string object that is to be included in the extracted substring.
count: The number of characters to extract from this string object. If this parameter is not supplied, then the remainder of the string is extracted.

See also:

• Mid(first as Integer) as SQLStringMBS

SQLStringMBS.Operator_Convert as string

See also:

• Operator_Convert(text as string)

SQLStringMBS.Operator_Convert(text as string)

See also:

• Operator_Convert as string

SQLStringMBS.Right(count as Integer) as SQLStringMBS

SQLStringMBS.TrimLeft

Some examples using this method:

• /SQL/SQL Unit Tests

SQLStringMBS.TrimRight

Some examples using this method:

• /SQL/SQL Unit Tests