Esempio n. 1
0
 /**
  * @see DBManager::massageValue()
  */
 public function massageValue($val, $fieldDef, $forPrepared = false)
 {
     $type = $this->getFieldType($fieldDef);
     $ctype = $this->getColumnType($type);
     // Deal with values that would exceed the 32k constant limit of DB2
     //Note we assume DB2 counts bytes and not characters
     if (strpos($ctype, 'clob') !== false && strlen($val) > 32000 && !$forPrepared) {
         $chunk = '';
         // Incrementing with number of bytes of chunk to not loose any characters
         for ($pos = 0, $i = 0; $pos < strlen($val) && $i < 5; $pos += strlen($chunk), $i++) {
             //mb_strcut uses bytes and shifts to left character boundary for both start and stop if necessary
             $chunk = mb_strcut($val, $pos, 32000);
             if (!isset($massagedValue)) {
                 $massagedValue = "TO_CLOB('{$chunk}')";
             } else {
                 $massagedValue = "CONCAT({$massagedValue}, '{$chunk}')";
             }
         }
         return $massagedValue;
     }
     $val = parent::massageValue($val, $fieldDef, $forPrepared);
     if (!$forPrepared) {
         switch ($type) {
             case 'blob':
             case 'longblob':
                 $val = 'SYSIBM.BLOB(' . $val . ')';
                 break;
         }
     }
     return $val;
 }
Esempio n. 2
0
 /**
  * @see DBManager::massageValue()
  */
 public function massageValue($val, $fieldDef, $forPrepared = false)
 {
     $type = $this->getFieldType($fieldDef);
     $ctype = $this->getColumnType($type);
     if (!$forPrepared) {
         if ($ctype == 'clob') {
             return "EMPTY_CLOB()";
         }
         if ($ctype == 'blob') {
             return "EMPTY_BLOB()";
         }
     }
     if ($type == "date" && !empty($val)) {
         $val = explode(" ", $val);
         // make sure that we do not pass the time portion
         return parent::massageValue($val[0], $fieldDef, $forPrepared);
         // get the date portion
     }
     return parent::massageValue($val, $fieldDef, $forPrepared);
 }