|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2006-04-16 22:17 UTC] tony2001@php.net
[2006-05-20 18:34 UTC] e dot mauviere at geoclip dot fr
[2008-01-22 15:31 UTC] maciej dot pijanka at gmail dot com
[2008-10-13 13:45 UTC] felipe@php.net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Oct 25 12:00:01 2025 UTC |
Description: ------------ Impossible to retrieve properly binary data from a binary field in Postgresql. It should work with the SQL BINARY CURSOR OPTION in Postgres, but data returned is truncated. Reproduce code: --------------- CREATE TABLE test(binfield byteA) ; INSERT INTO test VALUES (decode('0103AA000812','hex')); //First try $data =pg_query("SELECT binfield FROM test"); $res=pg_fetch_result($data,0); echo $res; // =>"\001\003\252\000\010\022" echo bin2hex(pg_unescape_bytea($res)); //=> "0103aa000812" //By default, Potsgresql returns binary field values as strings, so we need to unescape them to restore original binary data. Tedious. Performance issue here. //second try $sql="BEGIN;DECLARE mycursor BINARY CURSOR FOR SELECT binfield FROM test;fetch all in mycursor;"; //the BINARY CURSOR option forces PostgreSQ to return binary data $data =pg_query($sql); $res=pg_fetch_result($data,0); echo strlen($res); //=> 3 echo bin2hex($res); //=> 0103aa //BUG : data returned is truncated, as soon as a "00" byte is encountered, Expected result: ---------------- i am expecting to retrieve full binary content