Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.3
    • Fix Version/s: 2.0.5
    • Component/s: None
    • Labels:
      None
    • Environment:
      Linux Ubuntu 10.10 x86_64, PHP 5.3.3-1ubuntu9.3, mysql Ver 14.14 Distrib 5.1.49

      Description

      I have a Doctrine 2 entity and the value is mapped like this (with regular getter/setter):

       
      /**
       * @Column(type="decimal", precision=40, scale=30)
       */
      protected $someValue;
      
      /**
       * @return decimal
       */
      public function getSomeValue()
      {
          return $this->someValue;
      }
      
      /**
       * @param decimal $someValue
       */
      public function setSomeValue($someValue)
      {
          $this->someValue = $someValue;
      }
      

      When I set that value from my code, the value gets written into the database correctly. But, and that is my problem, when I get the value (via getter or \Doctrine\Common\Util\Debug::dump()), it always gives me a number with maximum 14 digits, and it rounds the value. I read the record with the default findById().

      eg: with value 1234567890.012345678901234567890123456789 I have 1234567890.0123
      eg: with value 890.0123456789012345678901234567890123456 I have 890.01234567890

      I of course want all digits, not just 14. The field in MySQL is declared like this:

       
          someValue decimal(40,30) NOT NULL,
      

      When I get the value with raw PHP and mysql_query(), it returns correctly.

      It seems like the problem is that Doctrine returns a float: ["someValue":protected]=> float(234567890.01235)

      What's wrong, what should I check next, how to fix, any clues?
      (also posted on http://stackoverflow.com/questions/5635500/doctrine-2-decimal-can-only-contain-14-digits)

        Activity

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Tom Van Looy
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: