db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Generic data types
Date Thu, 27 Sep 2007 14:36:04 GMT
> However, in practice, the 'TagValue' may be of different data types (float,
> varchar, int,  etc). The right data type is known only at runtime.

Here's a couple of ideas:

- Declare the column as a string, and convert the various data types
   to and from string format when storing/retrieving them.

- Declare multiple columns, each of the appropriate data type for its
   value, and use the right column for the right data type

thanks,

bryan


Mime
View raw message