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