Subject Re: [Firebird-Java] DatabaseMetaData ?
Author Blas Rodriguez Somoza
Hello

I commit today a patch to CVS for those two bugs, can you test it?

Regards
Blas Rodriguez Somoza.


At 02/05/2003 05:00 +0000, tsangccn wrote:
>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
>
>
>
>
>To unsubscribe from this group, send an email to:
>Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/