Subject | Re: [IB-Java] Re: bugs in DatabaseMetaData |
---|---|
Author | David Jencks |
Post date | 2001-11-04T06:04:42Z |
And now I fixed the PRECISION at least for dialect 3.
On 2001.11.04 00:51:59 -0500 David Jencks wrote:
> Ok, I think I fixed this one (tests work w/o trim) although the PRECISION
> named column is still a problem...
>
> david jencks
>
> On 2001.11.03 15:50:37 -0500 Massimo Ferrari wrote:
> > > That's somewhat annoying that it works the way it does, isn't it?
> > Yes, it is.
> >
> > > However, the nature of a CHAR(31) column is that it gets blank-padded
> > to
> > the
> > > declared width, so the fact that it comes back with trailing blanks
> > > isn't so surprising.
> > No it isn't, but from the user point of view, how meta data is stored
> in
> > the
> > database does not matter;
> > what matters is the result.
> > The JDBC specs say that e.g. getTables -> "TABLE_NAME" should return
> > the table name, i.e. the name I gave to the table, not a blank
> > padded-string.
> >
> > > I'm curious to know if you've worked with other JDBC-driver/DB-engine
> > > combinations that had different behavior for a CHAR type column (as
> > > opposed to say VARCHAR).
> > I worked with other dbs, and I never had problems with
> DatabaseMetaData.
> > If I declare a field as CHAR(31), I expect to get a padded string, but
> if
> > I
> > query for the column name I expect to get exactly the real name,
> because
> > it
> > is meta data.
> > BTW, this problem does not exist with InterClient.
> >
> > Massimo
> >
> >
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > IB-Java-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> >
>
> To unsubscribe from this group, send an email to:
> IB-Java-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>