[Dbix-class] Enumerated type

Lee Standen nom at standen.id.au
Tue Nov 7 08:16:07 GMT 2006


Other databases do support it as well, but (for DB2 for instance) it's 
stored as a constraint rather than a column data type.  If you're 
building the schema from your database type, check the column_info and 
see if it's actually populating that information?



Daniel Westermann-Clark wrote:
> On 2006-11-06 23:54:37 +0000, Josef Karthauser wrote:
>> Is it possible to extract a list of possible values for an
>> enumerated type using DBIx?  I think that this is possible in
>> Class::DBI, so I expect it's possible here too, but I can't find it
>> in the docs.
> 
> After a quick grepping of the source, it doesn't appear to have come
> up before.
> 
> MySQL supports enumerated types, but are there others?  I suspect such
> things are fairly database specific, and thus would need to be
> implemented in the appropriate Storage::DBI subclass.  Perhaps an
> enum_values('column_name') on ResultSource which checks for support on
> the storage?
> 



More information about the Dbix-class mailing list