List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 16 2008 10:19pm
Subject:Re: MySQL 5.0.51a and SHOW ENGINES
View as plain text  
At 2:57 PM -0400 4/16/08, Jim Winstead wrote:
>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.

RIght:

"--column-type-info, -m
Display result set metadata. This option was added in MySQL 5.1.14. 
(Before that, use --debug-info.) The -m short option was added in 
MySQL 5.1.21."

"--debug-info, -T

Before MySQL 5.1.14, this option prints debugging information and 
memory and CPU usage statistics when the program exits, and also 
causes display of result set metadata during execution. As of MySQL 
5.1.14, use --column-type-info to display result set metadata."

http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
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