Method Description

PgsqlConnection.binaryEscape()

Convert (potentially) unsafe binary data to a safe SQL string (BYTEA types)

See Also

Syntax

string = PgsqlConnection.binaryEscape()

Parameters

The 'PgsqlConnection.binaryEscape' method takes no parameters

Results

The 'PgsqlConnection.binaryEscape' method returns string:

Remarks

This method allows a Presentation Page to take any arbitrary binary object to be stored in the database and convert it to a safe text string that can be used to build up a SQL statement.

This method allows an application to store things like JPEG of GIF images within a database object. Generally the schema colum type for storing the binary data is 'BYTEA'.

Generally the parameter you will be passing to this method will be a Binary object, but you can pass any parameter type. All types except Binary objects are first converted to a string before being escaped.

This is a class method - don't call aConnection.binaryEscape(), instead call PgsqlConnection.binaryEscape().