When using the Table Design dialog to create or modify a table,
the default value for the Length property of a given Field Type is not
used. This occurs when a field's Field Type is change to another and
then changed back.
Specifically, this is true for Text [VARCHAR] and Text [CHAR].
Examples: Create a table in Design View (opens the Table Design
dialog). Enter a name for a field. The Field Type is automatically
listed as Text [VARCHAR] Note the Length property. Change the Field Type
to Yes/No [BOOLEAN]. The Length property changes to 1. Change the Field
Type back to Text [VARCHAR]. The Length property remains 1. Change the
Field Type to Binary [BINARY] and not the Length. Now change the Field
Type back to Text [VARCHAR]. The Length property does not change.
This is also a bug in LO going back at least as far as 3.4.4. A
bug report has been filed: Bug #53591. View it here:
https://bugs.freedesktop.org/show_bug.cgi?id=53591 for possible
additional information.
--Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
