DB.FormatBlob (gb.db)
Static 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'
|