php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #8352 mysql_field_len on a decimal field only report the length before the dot
Submitted: 2000-12-21 09:30 UTC Modified: 2001-04-25 13:43 UTC
From: zbinden at dataflow dot ch Assigned:
Status: Closed Package: MySQL related
PHP Version: 4.0.2 OS: linux 2.2.x
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: zbinden at dataflow dot ch
New email:
PHP Version: OS:

 

 [2000-12-21 09:30 UTC] zbinden at dataflow dot ch
mysql_field_len on a decimal field only report
the length before the dot:

create table articles (
     articleid int(11) primary key auto_increment,
     price decimal (9,2)
);

mysql_field_len on the field decimal returns
a 9. I think it should be a 12 (9 before, 2 after
and 1 for the point)?





Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-04-25 13:43 UTC] rasmus@php.net
User misunderstood how MySQL's decimal() works.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Wed May 07 10:01:28 2025 UTC