List:General Discussion« Previous MessageNext Message »
From:Jim Winstead Date:April 16 2008 6:57pm
Subject:Re: MySQL 5.0.51a and SHOW ENGINES
View as plain text  
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
> 3
> > > 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.

jim
Thread
MySQL 5.0.51a and SHOW ENGINESMartijn Tonies10 Apr
  • Re: MySQL 5.0.51a and SHOW ENGINESMartijn Tonies10 Apr
  • Re: MySQL 5.0.51a and SHOW ENGINESJim Winstead10 Apr
  • Re: MySQL 5.0.51a and SHOW ENGINESMartijn Tonies11 Apr
    • Re: MySQL 5.0.51a and SHOW ENGINESJim Winstead16 Apr
      • Re: MySQL 5.0.51a and SHOW ENGINESPaul DuBois17 Apr
  • Re: MySQL 5.0.51a and SHOW ENGINESMartijn Tonies17 Apr