ingres_set_environment

(PECL ingres >= 1.2.0)

Set 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.

Parameters:

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

Returns:

Returns TRUE on success or FALSE on failure.

Examples:

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";
    }
}
?>

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";
    }
}
?>