RE: MySQL 5.0 error after upgrade

2006-01-19 Thread Kerry Frater
- 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

Re: MySQL 5.0 error after upgrade

2006-01-18 Thread Gleb Paharenko
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

MySQL 5.0 error after upgrade

2006-01-17 Thread Kerry Frater
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