Thanks, I'll look to see how to use the system. But you are right that there is an issue somewhere given that the automatic code produced by Administrator, Control Centre and Browser all have problems with communicating with the tables following the upgrade.
Kerry -----Original Message----- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: 18 January 2006 15:57 To: mysql@lists.mysql.com Subject: Re: MySQL 5.0 error after upgrade Hello. > ALTER TABLE `filos`.`settings` MODIFY COLUMN `IntVal` INTEGER >CHARACTER SET latin1 COLLATE latin1_general_ci; This seems like a bug. MySQL Administrator should not assign character set to integer columns. See: http://dev.mysql.com/doc/refman/5.0/en/bug-reports.html Kerry Frater wrote: > Can someone help me. > > I was running v4 and just upgraded the version to v5.0. > > Most of my tables are MyISAM with some InnoDb. Most of the MyISAM tables are > char fields but a few have integer columns. When trying to create a new > table using the Administrator 1.1 program it is fine creating columns which > are of type "char" but it fails when creating a column of type "integer". > The error message is > ALTER TABLE `filos`.`settings` MODIFY COLUMN `IntVal` INTEGER CHARACTER SET > latin1 COLLATE latin1_general_ci; > > Can someone advise me what has changed in the upgrade and how I can get back > to using "integers"? > > kERRY > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]