binary cursor returning truncated data

binary cursor returning truncated data

am 12.04.2006 16:20:17 von e.mauviere

This is a multi-part message in MIME format.

------=_NextPart_000_01DD_01C65E4C.FCCC9830
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,

i am trying to retrieve binary content of a bytea field (or postgis =
geometry field) with a binary cursor with PHP :

$sql=3D"BEGIN;DECLARE mycursor BINARY CURSOR FOR SELECT shape FROM =
$layerName; fetch all in mycursor;"
.....pg_query...=20

But my shape field shows only two bytes of data.
=20
Does someone know if it is a current PHP restriction ?

Thanks by advance,

Eric
------=_NextPart_000_01DD_01C65E4C.FCCC9830
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">




Hello,

 

i am trying to retrieve binary content =
of a bytea=20
field (or postgis geometry field) with a binary cursor with PHP =
:

 

$sql=3D"BEGIN;DECLARE mycursor BINARY =
CURSOR FOR=20
SELECT shape FROM $layerName; fetch all in mycursor;"

....pg_query...

 

But my shape field shows only two =
bytes of=20
data.

 

Does someone know if it is a current =
PHP=20
restriction ?

 

Thanks by advance,

 

Eric


------=_NextPart_000_01DD_01C65E4C.FCCC9830--