Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save phpdave/7c61b6235dd136711580 to your computer and use it in GitHub Desktop.
Save phpdave/7c61b6235dd136711580 to your computer and use it in GitHub Desktop.
<?php
$sql="SELECT
CAST(1 as smallint) as smallint,
CAST(2 as INTEGER) as INTEGER,
CAST(3 as BIGINT) as BIGINT,
CAST(4. as real) as real,
CAST(5.1 as FLOAT) as FLOAT,
CAST(6.1 as DOUBLE) as DOUBLE,
CAST(7.1 as DECIMAL) as DECIMAL,
CAST(8.1 as NUMERIC) as NUMERIC,
CAST('9.1' as CHAR(4)) as CHAR,
CAST('10.1' as VARCHAR(4)) as VARCHAR,
CAST('10.1' as CLOB) as CLOB,
CAST(x'7FFF' as BINARY) as BINARY
FROM SYSIBM.SYSDUMMY1";
$stmt = db2_exec($db2Connection,$sql);
$row = db2_fetch_assoc($stmt) ;
var_dump($row);
array(12) {
["SMALLINT"]=>
int(1)
["INTEGER"]=>
int(2)
["BIGINT"]=>
string(1) "3"
["REAL"]=>
float(4)
["FLOAT"]=>
float(5.1)
["DOUBLE"]=>
float(6.1)
["DECIMAL"]=>
string(1) "7"
["NUMERIC"]=>
string(1) "8"
["CHAR"]=>
string(4) "9.1 "
["VARCHAR"]=>
string(4) "10.1"
["CLOB"]=>
string(4) "10.1"
["BINARY"]=>
string(1) ""
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment