On Fri, Apr 11, 2008 at 08:54:26AM +0200, Martijn Tonies wrote:
> Hello Jim,
> > On Thu, Apr 10, 2008 at 09:32:43AM +0200, Martijn Tonies wrote:
> > > It seems that SHOW ENGINES fails on MySQL 5.0.51a (community edition
> > > checked).
> > >
> > > Instead of returning the full data, the first two columns are cut off at
> > > characters,
> > > while the "comment" column is cut off at 26 characters.
> > sounds like you are using the wrong value for the length of a utf8
> > field, where the number of characters is being divided by the max
> > character length. (10 / 3 = 3, 80 / 3 = 26)
> > or it could be the server returning the wrong length. use "mysql
> > --column-type-info" to see what it is returning.
> That doesn't work with 5.0 as far as I can tell.
sorry, i think --column-type-info is new in 5.1. you can get the same
effect using -T with 5.0, i believe.