Platforms to show: All Mac Windows Linux Cross-Platform

SQLStringMBS class

dim s as new SQLStringMBS("Hello äöü")

MsgBox "Characters: "+str(s.GetLength)+" Bytes: "+str(s.GetBinaryLength)

dim a as string= s.CopyBinaryData
dim b as string= s.CopyText

MsgBox a // RB shows garbage as it tries to display bytes as UTF8 which does not work
MsgBox b // displays correct

• 4 properties
  • property BinaryLength as UInt32
  • property DebugText as String
  • property IsEmpty as boolean
  • property Length as UInt32
• 24 methods
  • method Compare(text as SQLStringMBS) as Integer
  • method Compare(text as string) as Integer
  • method CompareNoCase(text as SQLStringMBS) as Integer
  • method CompareNoCase(text as string) as Integer
  • method Constructor
  • method Constructor(Data as MemoryBlock)
  • method Constructor(Data as string, isText as Boolean = True)
  • method Constructor(other as SQLStringMBS)
  • method CopyBinaryData as string
  • method CopyMemoryBlock as MemoryBlock
  • method CopyText as string
  • method Empty
  • method Left(count as Integer) as SQLStringMBS
  • method MakeLower
  • method MakeUpper
  • method Mid(first as Integer) as SQLStringMBS
  • method Mid(first as Integer, Count as Integer) as SQLStringMBS
  • method Operator_Convert as string
  • method Operator_Convert(text as string)
  • method Right(count as Integer) as SQLStringMBS
  • method TrimLeft
  • method TrimRight

Sub classes:

• class SQLBytesMBS
• class SQLLongOrLobMBS
  • class SQLBLobMBS
  • class SQLCLobMBS
  • class SQLLongBinaryMBS
  • class SQLLongCharMBS

Some methods using this class:

• SQLBLobMBS.Constructor(data as SQLStringMBS)
• SQLBytesMBS.Constructor(data as SQLStringMBS)
• SQLLongBinaryMBS.Constructor(data as SQLStringMBS)
• SQLValueMBS.setAsBlob(data as SQLStringMBS)
• SQLValueMBS.setAsLongChar(text as SQLStringMBS)
• SQLValueMBS.setAsString(value as SQLStringMBS)
• SQLValueReadMBS.asBytes as SQLStringMBS
• SQLValueReadMBS.asLongBinary as SQLStringMBS
• SQLValueReadMBS.asLongChar as SQLStringMBS
• SQLValueReadMBS.asString as SQLStringMBS

Some examples using this class:

• /SQL/MySQL ExecuteSQL with Parameters
• /SQL/MySQL Write blob to file
• /SQL/SQL Unit Tests
• /SQL/SQLite ExecuteSQL with Parameters
• /SQL/SQLite Unicode test
• /SQL/SQLite Write blob to file

Blog Entries

• MBS Xojo Plugins, version 24.0pr6
• MBS Real Studio Plugins, version 12.4pr9

Release notes

• Version 24.0
  • Added CopyMemoryBlock method to SQLStringMBS class.

The items on this page are in the following plugins: MBS SQL Plugin.

SQLPreparedStatementMBS   -   SQLUnsupportedExceptionMBS