Skip to content

SQLSRV_ATTR_FORMAT_DECIMALS does not work using SQLSRV_CURSOR_BUFFERED #1525

@DAdq26

Description

@DAdq26

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions