Option #1: Use an INTEGER column and bit positions for the different days Option #2: Serialize the strings into a comma-separated list or similar structure and store the result in a TEXT column
On Mon, Dec 27, 2010 at 5:38 AM, pramod.deore <[email protected]> wrote: > Hi, I have a String array (which contains some day from Monday - > Sunday). But which days are stored is decided at runtime means > sometime it want to store all day or sometime 1 or none. Now I want to > store this array in database. How to save array of string in database? > Or should I create 7 columns in that table? -- Mark Murphy (a Commons Guy) http://commonsware.com | http://github.com/commonsguy http://commonsware.com/blog | http://twitter.com/commonsguy Warescription: Three Android Books, Plus Updates, One Low Price! -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
