To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62664
------- Additional comments from [EMAIL PROTECTED] Mon Aug 21 23:45:14 -0700 2006 ------- > confusion: the VARCHAR default value are two: 50 and 254. when you create > a new VARCHAR field, the default max lenght is 50. but if you chang the > datatype to LONGVARCHAR, and then check back to VARCHAR, the default > max lenght is 254. The 50 for a newly created VARCHAR is an arbitrary fixed value. For LONGVARCHAR, the length is fixed to 65535. When then switching back to VARCHAR, the table designer tries to preserve as much of this as possible - which results in 254, since this is the maximum for VARCHAR. --------------------------------------------------------------------- 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]
