Re: char(1) vs Number(1)
From: CrazyKarma <skalki_at_gmail.com>
Date: Thu, 3 Dec 2009 13:55:45 -0800 (PST)
Message-ID: <a7a8c23d-1a4e-4be1-a2ef-559634d2febb_at_k13g2000prh.googlegroups.com>
Finally I settled for the idea of storing the decimal number representing the binary in one column and then BITAND to identify which bit was set. This will help me decouple table schema to new additions of lookup types. I guess Mark was alluding to this earlier.
Date: Thu, 3 Dec 2009 13:55:45 -0800 (PST)
Message-ID: <a7a8c23d-1a4e-4be1-a2ef-559634d2febb_at_k13g2000prh.googlegroups.com>
Finally I settled for the idea of storing the decimal number representing the binary in one column and then BITAND to identify which bit was set. This will help me decouple table schema to new additions of lookup types. I guess Mark was alluding to this earlier.
Thanks all
CK Received on Thu Dec 03 2009 - 15:55:45 CST