To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92089 Issue #|92089 Summary|Flag ZEROFILL for INT fields is ignored in MySQL datab |ases. Component|Database access Version|OOo 3.0 Beta 2 Platform|Macintosh URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|johnopen
------- Additional comments from [EMAIL PROTECTED] Thu Jul 24 13:06:27 +0000 2008 ------- The database application does not display fields of the type INT with the flag ZEROFILL enabled correctly; the flag is ignored and numbers are displayed without leading zeroes. I tested this with a MySQL database containing an innoDB table with one field set as INT(8) ZEROFILL NULL. When editing the table in OpenOffice Base Beta numbers like 00000123 are displayed as 123. When adding or editing a number MySQL will store it properly and other applications used to view the data do append the zeroes. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
