Subject DatabaseMetaData ?
Author tsangccn
Hello

I have download Jaybird 1.0.0. But it seems that there is some error
in DatabaseMetaData.

I have created a table using the following SQL

create table bb (f1 char(10) default 'ABC', f2 numeric(7,2) default
-1, f3 decimal(7,2) default -1)

The default character set is UNICODE_FSS and the dialect is 3.

(1) --------------------

DatabaseMetaData.getColumns() gives the following with column f1

COLUMN_SIZE = 30
CHAR_OCTET_LENGTH = 0

But the correct value should be

COLUMN_SIZE = 10
CHAR_OCTET_LENGTH = 30

with the following reasons

COLUMN_SIZE => column size. For char or date types this is the maximum
number of characters, for numeric or decimal types this is precision.
CHAR_OCTET_LENGTH => for char types the maximum number of bytes in the
column

(2) --------------------

The COLUMN_DEF for the 3 columns are null ?


Thank
CN