enum() good idea or bad?

Discussion in 'Databases' started by mz906, Jan 16, 2009.

  1. #1
    Just wanted to get some input on this one...

    is it a good idea or bad idea to use enum() ?

    some say it makes it to complicated cause of the syntax

    I'm speicifly building a table where i'll have a 'type' of content, such as; image, post, story, etc...

    is this enum() recommended?
     
    mz906, Jan 16, 2009 IP
  2. mrhrk01

    mrhrk01 Well-Known Member

    Messages:
    664
    Likes Received:
    28
    Best Answers:
    0
    Trophy Points:
    145
    #2
    I think enum(the enumerator type field for databases can be used and used well.) Ofcourse it depends on your database and how you intend for it to be used etc, but the sytnax is not complex if you do want to use the enumerator type for a field.

    I sugest maybe creating a database/table(or both if needed) and have a play with the enum field type and see how it works and whether you think thatis what you require or not.

    Kind Regards
     
    mrhrk01, Jan 17, 2009 IP