From: Martijn Tonies Date: April 17 2008 7:43am Subject: Re: MySQL 5.0.51a and SHOW ENGINES List-Archive: http://lists.mysql.com/mysql/212347 Message-Id: <00cc01c8a05e$c164ae30$9902a8c0@martijnws> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hello Jim, > > > 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. Thanks for the suggestion but the issue has been fixed for me. I reported it to the vendor that created the Delphi component-set to use MySQL and they supplied me with a fix. Apparently, "something" has changed between 5.0.45 and 5.0.51 that made their code fail, but it's all good now. Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com