Gambas Documentation - /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'`