I did not test well before posting previous code. This if statement works and the other does not.
if( ocicolumnscale($R, $i ) != 129 )
{
$int_decimal = ocicolumnscale($R, $i );
$int_length = ocicolumnprecision($R, $i) - $int_decimal;
}
oci_field_precision
(PHP 5, PECL OCI8 >= 1.1.0)
oci_field_precision — Tell the precision of a field
Beskrivelse
int oci_field_precision
( resource
$statement
, int $field
)
Returns precision of the field.
For FLOAT columns, precision is nonzero and scale is -127. If precision is 0, then column is NUMBER. Else it's NUMBER(precision, scale).
Parametre
-
statement -
A valid OCI statement identifier.
-
field -
Can be the field's index (1-based) or name.
Returnerings Værdier
Returns the precision as an integer, or FALSE on errors.
Noter
Note:
In PHP versions before 5.0.0 you must use ocicolumnprecision() instead. This name still can be used, it was left as alias of oci_field_precision() for downwards compatability. This, however, is deprecated and not recommended.
Se også
- oci_field_scale() - Tell the scale of the field
- oci_field_type() - Returns field's data type
add a note
User Contributed Notes 2 notes
webmaster at smwebdesigns dot com ¶
16 years ago
webmaster at smwebdesigns dot com ¶
16 years ago
I've found that when using ocicolumnprecision or oci_field_precision it will not show you the decimal places if you are are reading from tables with decimals. You can use ocicolumnscale or oci_field_scale to find the decimal.
if( ocicolumnscale($R, $i ) > 0 )
{
$int_decimal = ocicolumnscale($R, $i );
$int_length = ocicolumnprecision($R, $i) - $int_decimal;
}
