Re: Best practice - variable number of fields
> Should I have separate integer fields to record their hobbies, like "Hobby1", "Hobby2"
Never.
> or should I have just one varchar field "Hobby" where I concatenate the hobbies separated by semicolons?
Not good either, or it is data you never use. When you're going to search people on their hobbies, you need three tables
hobby
user
user_hobby
user_hobby contains the primary key from user and the primary key from hobby.
Subject
Views
Written By
Posted
2954
July 03, 2009 08:45AM
Re: Best practice - variable number of fields
2055
July 04, 2009 06:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.