Sorry, the PHP-Version is 5.2.5

Hi,

The following works for me:

<?php
   require_once('fvt.inc');
   class Test extends FVTTest
   {
      public function runTest()
      {
         $this->connect();

         try {
            /* Drop the test table, in case it exists */
            $drop = 'DROP TABLE animals';
            $result = $this->db->exec( $drop );
         } catch( Exception $e ){}

         /* Create the test table */
         $create = 'CREATE TABLE animals (id INTEGER, my_clob clob)';
         $result = $this->db->exec( $create );

         $fp = fopen( dirname(__FILE__) . "/large_clob.dat" , "r" );
         $stmt = $this->db->prepare('insert into animals (id, my_clob) values (?, ?)');
         print "inserting from file stream\n";
         $zero = 0;
         $stmt->bindParam( 1, $zero );
         $stmt->bindParam( 2 , $fp , PDO::PARAM_LOB );
         $stmt->execute();
         print "succesful\n";

         print "runnign query\n";
         $stmt = $this->db->prepare( 'select id, my_clob from animals' );

         $stmt->bindColumn( 'ID' , $id );
         $stmt->bindColumn( 'MY_CLOB' , $clob , PDO::PARAM_LOB );
         $rs = $stmt->execute();
         while ($stmt->fetch(PDO::FETCH_BOUND)) {
            var_dump( $id );
            var_dump( $clob );
         }
         print "done\n";
      }
   }

   $testcase = new Test();
   $testcase->runTest();
?>

Do you have a test case I can use to re-create this issue? Also, please update to the latest version of PDO_INFORMIX and check if you still get an error.  

Thanks.

It works with correct error statements now.
But it doesnt recognize german Date formats.

DBDATE is DMY4.

If i use '14.03.2008' it doesnt work.
If i use '2008-03-14' it work.

Hi, 

Please make sure that you are setting the DBDATE variable on the machine where the CSDK is installed. I have tried to re-create this issue and the following works:

<?php
   require_once('fvt.inc');
   class Test extends FVTTest
   {
      public function runTest()
      {
         $this->connect();

         try {
            /* Drop the test table, in case it exists */
            $drop = 'DROP TABLE animals';
            $result = $this->db->exec( $drop );
         } catch( Exception $e ){}

         /* Create the test table */
         $create = 'CREATE TABLE animals (id INTEGER, a_date DATE)';
         $result = $this->db->exec( $create );

         $stmt = $this->db->prepare('insert into animals (id, a_date) values (?, ?)');
         print "inserting from file stream\n";
         $zero = 0;
         $a_date = '14.03.2008';
         $stmt->bindParam( 1, $zero );
         $stmt->bindParam( 2, $a_date );
         $stmt->execute();
         print "succesful\n";

         print "runnign query\n";
         $stmt = $this->db->prepare( 'select id, a_date from animals' );

         $stmt->bindColumn( 'ID' , $id );
         $stmt->bindColumn( 'A_DATE' , $b_date );
         $rs = $stmt->execute();
         while ($stmt->fetch(PDO::FETCH_BOUND)) {
            var_dump( $id );
            var_dump( $b_date );
         }
         print "done\n";
      }
   }

   $testcase = new Test();
   $testcase->runTest();
?>

If it still does not work please provide a test case. 

Thanks.

This is my test case.

dbschema:
{ TABLE "informix".leps row size = 204 number of columns = 8 index size = 30 }
create table "informix".leps
  (
    dokkey serial not null ,
    mandant char(3) not null ,
    nlnr char(4) not null ,
    persnr char(8) not null ,
    abrechdat date not null ,
    lohn char(7),
    lohnpdf "informix".clob,
    name char(100) not null
  );
revoke all on "informix".leps from "public";



create unique index "informix".ixkunstl2 on "informix".leps (dokkey)
    using btree ;
create unique index "informix".ixrow2 on "informix".leps (nlnr,
    persnr,abrechdat) using btree ;

PHP-Source:

session_start(); 
$session = session_id();

ini_set("error_reporting",E_ALL);

    try
    { 
        $db = new PDO('informix:host=primergy.konzern.intern; service=1528; database=pdfarchiv; server=tcp_primergy; protocol=onsoctcp; TRANSLATIONDLL=/opt/informix/lib/esql/igo4a304.so');
        $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);    
    
    	$var     = '123456';
    	$monat   = '10.01.2007';
    	//$monat   = '2007-01-10';
    	$mandant = 'PS';
    	    	
    	$stmt    = $db->prepare("SELECT lohnpdf FROM leps WHERE persnr=? AND abrechdat =? AND mandant=?");
		$stmt->bindParam(1, $var);
    	$stmt->bindParam(2, $monat);
    	$stmt->bindParam(3, $mandant);
    	$stmt->execute();
        $stmt->bindColumn(1, $lob, PDO::PARAM_LOB);                
    	$stmt->fetch(PDO::FETCH_BOUND);
    	header("Content-type: application/pdf");
    	header("Content-Transfer-Encoding: binary");
    	fpassthru($lob);
    	
    } catch (PDOException $error) {
    	Echo "SQL-Error: " . $error->getMessage();
    	//print_r($stmt->errorInfo());   	
    	exit;
    }  


If you switch $monat from '2007-01-10' to '10.01.2007', i get the following error:

SQL-Error: SQLSTATE[22018]: Invalid character value for cast specification: -11106 [Informix][Informix ODBC Driver]Invalid character value for cast specification. (SQLExecute[4294956190] at /tmp/pear/cache/PDO_INFORMIX-1.2.0/informix_statement.c:730)

Hi..

We are currently looking into it. Would get back to you ASAP. Thanks for the bug report. Meanwhile it would be helpful to know the IDS version being used.

IBM Informix Dynamic Server Version 10.00.FC6

Hi..

The problem is supposedly with CSDK and not PDO-Informix. I have been able to run the code successfully on CSDK version 2.90 with Suse. We are trying to delve further into the problem and would let you know the status soon. Can you tell me the CSDK version you are using?? To know the CSDK version run "esql -V". Or can you try installing CSDK version 2.9 on your machine and check. 

Please note that if the format is any other than Y4MD-, you need to do an "export DBDATE=format" before execution of code.

Regards

# esql -V
IBM Informix CSDK Version 3.00, IBM Informix-ESQL Version 3.00.FC3DE
Software Serial Number AAA#B000000

If i open a phpinfo() website, it tells me under Environment that DBATE is DMY4.

One note:

If i do an insert with a german date format (DMY4.) but without a blob on a table with a blob, the IDS Instance Crashes without any note in the online.log

Code:
$date = '01.03.2008';
$stmt = $db->prepare("INSERT INTO leps (mandant, nlnr, persnr, abrechdat, name)
                      VALUES (?,?,?,?,?)");
$stmt->bindParam(4, $date);

If i use english formats, with and without the blob column in the insert sql, all is running fine.

$date = '2008-03-01';
$stmt = $db->prepare("INSERT INTO leps (mandant, nlnr, persnr, abrechdat, name, blob)
                      VALUES (?,?,?,?,?,?)");
$stmt->bindParam(4, $date);

Can you try and install CSDK-2.9 locally on some other location, connect to Informix server using your DSN and check if it fails too? CSDK 2.9 passes for me.

Sure, ill give you a feedback in a few days.

Ok,

i installed CSDK 2.9
# esql -V
IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.FC4R1
Software Serial Number AAA#B000000

All is running fine now. No server crashes, and i can use german date formats.

Hi 

Please close this bug.

Thanks

Fixed

This problem still exists with CSDK 3.70FC1

"esql -V
IBM Informix CSDK Version 3.70, IBM Informix-ESQL Version 3.70.FC1"

So we are unable to select from fields like bigint since the csdk2.9 doesn't support this field types.

Thank you for taking the time to write to us, but this is not
a bug.

Hi,

There were few issue with DBDATE and hence after v2.9 of CSDK, this feature has been rolled back.

Regards,
Ambrish Bhargava

We want to upgrade to IDS 11.7FC1.
So how we deal with this defect? Stay with CSDK 2.9?
But than, we cant use IDS 11.7FC1

Hi,

As this is the problem with CSDK (and we can not do anything in PDO_INFORMIX extension), I suggest you talk to the CSDK/IDS team about this. May be open a PMR against IDS.

Regards,
Ambrish Bhargava