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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
