On Sun, Nov 22, 2009 at 11:26 AM, Aryeh Gregor
<Simetrical+wikilist(a)gmail.com> wrote:
Last I checked, edit summaries were just
passed to the database with no hard length check, so MySQL in
non-strict mode with a binary schema (like Wikipedia) will just
truncate them to fit. (In strict mode it will raise an error, and if
we used utf8 rather than binary it would presumably truncate by
characters.)
Hmm, okay. Should I be using character set and collation "binary"?
The dumps build the table using character set utf8, and don't say
anything about the collation. Is this specific to edit summaries, or
does it apply to all the text fields?
I guess this is getting off topic, but I'm not quite sure what the
topic of this thread is anyway.
On Sun, Nov 22, 2009 at 11:54 AM, Aryeh Gregor
<Simetrical+wikilist(a)gmail.com> wrote:
On Sun, Nov 22, 2009 at 11:45 AM, Ryan Chan
<ryanchan404(a)gmail.com> wrote:
May I ask why still using the 4.0 version? Seems
5.1 above did provide
much performance enhancements?
I'm not the one to ask. My understanding is that it's mostly a
question of how much administrative resources it would take to switch.
I don't know if it was supposed to be taken as sarcasm or not, but Tim
Starling recently commented that "it seems that I'm the only staff
member who knows MySQL." That was a joke, right?