PHP version 8.3
PHP PDO_SQLSRV version 5.12 with doctrine dbal
SQL Server version 2022 linux
Client operating system linux
Table schema
Problem description
When using db cx with option SQLSRV_ATTR_FORMAT_DECIMALS to true,
When i prepare statement with following attributes
[PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL, PDO::SQLSRV_ATTR_CURSOR_SCROLL_TYPE => PDO::SQLSRV_CURSOR_BUFFERED]
to get decimal from db
Leading 0 on decimal are missing
If i remove PDO::SQLSRV_ATTR_CURSOR_SCROLL_TYPE => PDO::SQLSRV_CURSOR_BUFFERED and fallback to defaut SQLSRV_ATTR_CURSOR_SCROLL_TYPE value the leading 0 is well added