ingres_rollback
ingres_unbuffered_query
Ingres Functions
PHP Manual

# ingres_set_environment

Set environment features controlling output options

### Description

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

### Return Values

Returns `TRUE` on success or `FALSE` on failure.

### Examples

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

### See Also

- ingres_connect
- ingres_query