| Subject | Re: [Firebird-Java] EDITING: JDBC - Firebird: Integer-fields formatted with wrong field properties |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2013-07-23T08:26:58Z |
On Tue, 23 Jul 2013 08:01:53 -0000, "mariuz"
<mariuz@...-dev.ro>
wrote:
10 seems right. The thing is a 32 bit integer has a maximum length (or
precision) of 10, and - IIRC - it is what Jaybird returns as the length in
the DatabaseMetaData.getColumns() in column COLUMN_SIZE, as required by
DatabaseMetaData.getColumns(): "The COLUMN_SIZE column specifies the column
size for the given column. For numeric data, this is the maximum precision.
[...]".
See
http://en.wikipedia.org/wiki/Integer_(computer_science)#Common_integral_data_types
<mariuz@...-dev.ro>
wrote:
> This happens in LibreOffice 4.1I will take a look at it, but at first glance the fact it says length is
>
> https://bugs.freedesktop.org/show_bug.cgi?id=67179
10 seems right. The thing is a 32 bit integer has a maximum length (or
precision) of 10, and - IIRC - it is what Jaybird returns as the length in
the DatabaseMetaData.getColumns() in column COLUMN_SIZE, as required by
DatabaseMetaData.getColumns(): "The COLUMN_SIZE column specifies the column
size for the given column. For numeric data, this is the maximum precision.
[...]".
See
http://en.wikipedia.org/wiki/Integer_(computer_science)#Common_integral_data_types