comp • gb.db • _connection • formatblob

Connection.FormatBlob (gb.db)

Function FormatBlob ( Data As String ) As String

Format some blob data into a quoted string that can be inserted into a SQL query.

Example

Here is the result of applying FormatBlob() to the string "'gambas' is not a blob\n".

Database

Result
SQLite X'2767616D62617327206973206E6F74206120626C6F620A'
MySQL '''gambas'' is not a blob\n'
PostgreSQL E'\'gambas\'is not a blob\012'
ODBC '''Gambas'' is not a blob\n'