Ingres º¯Êý
ÔÚÏßÊֲ᣺ÖÐÎÄ Ó¢ÎÄ
PHPÊÖ²á

ingres_set_environment

(PECL ingres >= 1.2.0)

ingres_set_environmentSet environment features controlling output options

˵Ã÷

bool ingres_set_environment ( resource $link , array $options )

ingres_set_environment() is called to set environmental options that affect the output of certain values from Ingres, such as the timezone, date format, decimal character separator, and float precision.

²ÎÊý

link

The connection link identifier

options

An enumerated array of option name/value pairs. The following table lists the option name and the expected type

Option name Option type Description Example
date_century_boundary integer The threshold by which a 2-digit year is determined to be in the current century or in the next century. Equivalent to II_DATE_CENTURY_BOUNDARY 50
timezone string Controls the timezone of the session. If not set, it will default the value defined by II_TIMEZONE_NAME. If II_TIMEZONE_NAME is not defined, NA-PACIFIC (GMT-8 with Daylight Savings) is used. UNITED-KINGDOM
date_format integer

Sets the allowable input and output format for Ingres dates. Defaults to the value defined by II_DATE_FORMAT. If II_DATE_FORMAT is not set, the default date format is US, for example mm/dd/yy. Valid values for date_format are:

  • INGRES_DATE_DMY
  • INGRES_DATE_FINISH
  • INGRES_DATE_GERMAN
  • INGRES_DATE_ISO
  • INGRES_DATE_ISO4
  • INGRES_DATE_MDY
  • INGRES_DATE_MULTINATIONAL
  • INGRES_DATE_MULTINATIONAL4
  • INGRES_DATE_YMD
  • INGRES_DATE_US

INGRES_DATE_ISO4
decimal_separator string The character identifier for decimal data ","
money_lort integer

Leading or trailing currency sign. Valid values for money_lort are:

  • INGRES_MONEY_LEADING
  • INGRES_MONEY_TRAILING

INGRES_MONEY_LEADING
money_sign string The currency symbol to be used with the MONEY datatype
money_precision integer The precision of the MONEY datatype 2
float4_precision integer Precision of the FLOAT4 datatype 10
float8_precision integer Precision of the FLOAT8 data 10
blob_segment_length integer The amount of data in bytes to fetch at a time when retrieving BLOB or CLOB data. Defaults to 4096 bytes when not set explicitly 8192

·µ»ØÖµ

³É¹¦Ê±·µ»Ø TRUE£¬ »òÕßÔÚʧ°Üʱ·µ»Ø FALSE.

·¶Àý

Example #1 Set date_format to ISO4

<?php
$options 
= array( "date_format" => INGRES_DATE_ISO4 );

if (
ingres_set_environment($link$options))
{
    
$result=ingres_query($link,"select date('now') as date");

    while ( 
$object ingres_fetch_object ($result) ) {
        echo 
$object->date."\n";
    }
}
?>

Example #2 Set timezone to HONG-KONG

<?php

$options 
= array( "timezone" => "HONG-KONG");

if (
ingres_set_environment($link$options))
{
    
$result=ingres_query($link,"select date('now') as date");

    while ( 
$object ingres_fetch_object ($result) ) {
        echo 
$object->date."\n";
    }
}
?>

²Î¼û


Ingres º¯Êý
ÔÚÏßÊֲ᣺ÖÐÎÄ Ó¢ÎÄ
PHPÊÖ²á