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

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