RE: [mysql] Text = Tinytext = MediumText = LongText?

2007-10-18 Thread Weston, Craig (OFT)
AM To: mysql@lists.mysql.com Subject: Re: [mysql] Text = Tinytext = MediumText = LongText? Sebastian Mendel schrieb: > Weston, Craig (OFT) schrieb: >> Hello everyone, hopefully a quick question: is there a functional >> difference between the various text field sizes other

Re: [mysql] Text = Tinytext = MediumText = LongText?

2007-10-18 Thread Sebastian Mendel
Sebastian Mendel schrieb: > Weston, Craig (OFT) schrieb: >> Hello everyone, hopefully a quick question: is there a functional >> difference between the various text field sizes other than size? For >> example if I wanted to could I run a FULLTEXT index against a LongText >> field? > > no ay ...

Re: [mysql] Text = Tinytext = MediumText = LongText?

2007-10-18 Thread Sebastian Mendel
Weston, Craig (OFT) schrieb: > Hello everyone, hopefully a quick question: is there a functional > difference between the various text field sizes other than size? For > example if I wanted to could I run a FULLTEXT index against a LongText > field? no -- Sebastian -- MySQL General Mailing Li

[mysql] Text = Tinytext = MediumText = LongText?

2007-10-17 Thread Weston, Craig (OFT)
Hello everyone, hopefully a quick question: is there a functional difference between the various text field sizes other than size? For example if I wanted to could I run a FULLTEXT index against a LongText field? The collary is of course how good of an idea is this, assuming that MOST of the d