To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106039 Issue #|106039 Summary|[cws:hsqldb19] New data types has wrong default values Component|Database access Version|DEV300m61 Platform|Unknown URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|r4zoli
------- Additional comments from [email protected] Mon Oct 19 13:54:28 +0000 2009 ------- I found that the newly introduced data types in 1.9 used in OOo, has a size default values used in Table design UI, BIT(16), BLOB(50), and CLOB(50). BIT is presented in UI as "BIT(Yes/No)", the 16 is wrong value, needs 1. BLOB needs to be in HSQLDB default value 1M, or more pictures can be huge and sometimes needs to stored in tables for portability, better to use some dropdown selection, or as in old version with LONGVARBINARY. CLOB is the same as BLOB. http://hsqldb.org/doc/2.0/guide/guide.html#sqlgeneral_types_ops-sect --------------------------------------------------------------------- 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]
