I'm not sure in DBI, but w/ JDBC, you have what called MetaData, and w/ that you can get info about the fied definition.
HTH --Yohans On Wed, 14 Nov 2001, Example user SuSE Linux 6.2 wrote: > Is it possible to use DBI to get the type of a field in a table? > If so, how? > > The point is that I want to have a portable script along mysql and > Oracle and > these may have different datatypes. So it might be best to query the > database > what datatype fieldx is, then use it to say create an auxilliary table > > Thanks, > S.Alexiou >
