[Nitro] RES: RES: updated_at and created_at
Jonathan Buch
john at oxyliquit.de
Thu Mar 15 11:41:10 EDT 2007
Hi,
> hmm, will see what I can do... is varchar(255) really better that Text?
yes it is, and then it isn't. The standard is and should be: don't break.
When using varchar, the application is probably (if not in the first tests)
failing later on, just because some text was slightly bigger.
Standard using TEXT prevents from those 'silent' failures. Not everyone
is using mysql where one can't compare on TEXT. :P
varchar is better, when you optimize the database layout, when you need
more speed, better disk usage. I woudn't propose optimization over
'doesn't fail'...
Having a Og::String(size) function doesn't hurt though I guess.
Jo
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
More information about the Nitro-general
mailing list