Hi Ronald, Sheeri, all,
On 14/08/2008, at 10:13 AM, Ronald Bradford wrote:
-1 Never see it in use with any client.
Agree with comment, idea for pluggable data type if needed.
The way it's implemented make it unusable - for indexing/lookup
purposes.
If you waste a bit of space you can get better usability/speed.
In training, I consider SET to be an evil data type.
Usually people use SET only because they don't understand the search/
speed consequences of its multi-valued columns.
The concept COULD be optimised with a specialised index system. As to
whether that's necessary... dunno.
Cheers,
Arjen.
On Wed, Aug 13, 2008 at 7:28 PM, Sheeri K. Cabral <[EMAIL PROTECTED]>
wrote:
On Wed, Aug 13, 2008 at 6:51 PM, Baron Schwartz <[EMAIL PROTECTED]>
wrote:
> I got pinged in email on "Why are you keeping SET?". I have zero
opinion on
> them because I have never used them.
>
> Here is an article from Mike Hillyer on them:
> http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html
>
> Are they useful? How many gotcha do they have? Should we just have
a true
> Bool type?
They are weird and not all that useful for most things.
ENUM is very useful for a lot of things, though.
++
ENUM and SET seem to "go together" although they don't have to.
I've used SET but eventually had to result to Jamie's BIT solution,
not because it was easier (bit flags are not easier than descriptive
text IMO!) but because of the 64 item limit in a SET.
But I've used set exactly twice, and I haven't seen anyone else
implementing set.
-Sheeri
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
--
Arjen Lentz, Founder @ Open Query
Training and Expertise for MySQL in Australia and New Zealand
http://openquery.com.au/training/ (ph. +61-7-3103 0809)
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
