PDO::PARAM for type decimal? PDO::PARAM for type decimal? database database

PDO::PARAM for type decimal?


There isn't any PDO::PARAM for decimals / floats, you'll have to use PDO::PARAM_STR.


UP must use the PDO::PARAM_STR same, and noting that if the column in the database is of type NUMERIC (M, D) or decimal (M, D) should be observed that the M is the number of characters precision should be the total of characters that you can enter, and D the number of decimal places. In the example NUMERIC (10,2) we have 8 houses to places of accuracy and two decimal places. So we have 10 characters in total with 2 reserved for decimal places.


I found a solution, send the decimal parameter like PDO::PARAM_STR, in the sql server store procedure receive it like decimal(int,dec)

PHP

$stmt_e->bindParam(':valor_escala_desde', $valor_escala_desde, PDO::PARAM_STR);

SQL SERVER, STORE PROCEDURE:

@valor_escala_desde decimal(18,2),

and is done.