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]
