   #PHP Manual PostgreSQL functions pg_end_copy pg_escape_string

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                                pg_escape_bytea

   (PHP 4 >= 4.2.0)
   pg_escape_bytea --  Escape binary for bytea type

Description

   string pg_escape_bytea ( string data)

   pg_escape_bytea() escapes string for bytea datatype. It returns
   escaped string.

     Note: When you SELECT bytea type, PostgreSQL returns octal byte
     value prefixed by \ (e.g. \032). Users are supposed to convert back
     to binary format by yourself.

     This function requires PostgreSQL 7.2 or later. With PostgreSQL
     7.2.0 and 7.2.1, bytea type must be casted when you enable
     multi-byte support. i.e. INSERT INTO test_table (image) VALUES
     ('$image_escaped'::bytea); PostgreSQL 7.2.2 or later does not need
     cast. Exception is when client and backend character encoding does
     not match, there may be multi-byte stream error. User must cast to
     bytea to avoid this error.

   See also pg_unescape_bytea() and pg_escape_string().
   ______________________________________________________________________

   Prev        Home             Next
   pg_end_copy  Up  pg_escape_string
