PHP, PDO & Zoned Decimal - Decimal Lost

Discussion in 'DB2' started by Ben Roberts, Dec 1, 2017.

  1. Ben Roberts

    Ben Roberts New Member

    I'm accessing IBMi DB2 for 7.1 using PHP 5.6 and PDO. When accessing the value in a column that is declared as zoned decimal type, the decimal portion of the number is not retrieved, but appears to be truncated or lost.

    Has anyone else encountered this issue and, if so, what (besides using a character to string data type to store decimal numbers) solutions have been used?
  2. Ben Roberts

    Ben Roberts New Member

    This actually appears to have been a bug between the chair and the keyboard and nothing more. Carry on. There is nothing to see here. =)

Share This Page