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