Subject | |
---|---|
Author | tsangccn |
Post date | 2003-05-02T04:58:11Z |
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 (default value) for the 3 columns are null ?
Thank
CN
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 (default value) for the 3 columns are null ?
Thank
CN