Gossamer Forum
Quote Reply
Creating a column ENUM
I am creating a couple of columns in a custom table and I want this particular one to be an ENUM (boolean?) with the options exclusivley 'Yes' or 'No'. What should I change to do this?

'ShowEmail' => {
pos => 12,
type => 'ENUM',
not_null => 1,
default => 'Yes',
size => 3
},



Also, I understand you can display 'Yes' or 'No' but record 1 or 0 in the database for performance gain. Is this really worth it? and if it is, how do I change this code to do it?

Thanks.


http://www.iuni.com/...tware/web/index.html
Links Plugins
Subject Author Views Date
Thread Creating a column ENUM Ian 2775 May 17, 2002, 11:23 PM
Thread Re: [sooke] Creating a column ENUM
Paul 2661 May 18, 2002, 2:10 AM
Thread Re: [] Creating a column ENUM
Wil 2654 May 18, 2002, 3:18 AM
Post Re: [Wil] Creating a column ENUM
Ian 2625 May 18, 2002, 8:52 AM