Page 1 of 1
Column 'Null' exceeds the MaxLength
Posted: Sat 12 Nov 2005 19:33
by bsd_01
I get this error when I issue this command:
describe events
events is my table name
Any Ideas?
Posted: Mon 14 Nov 2005 06:23
by Serious
Specify .NET Framework, MySQL, MySQLDirect .NET and OS version.
Include definition for 'events' table.
Posted: Mon 14 Nov 2005 07:49
by bsd_01
MySQL Direct is 3.05.4.0
.Net Framework is version 1.1.4322.573
OS is XP pro sp2
MySQL Version is 4.1.10a-nt
Table definition is:
CREATE TABLE c221_mallpro.events (
iID BIGINT(20) NOT NULL AUTO_INCREMENT UNIQUE,
sDescription VARCHAR(40) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'New Event',
tDate DATETIME DEFAULT '0000-00-00 00:00:00',
tDateEnd DATETIME DEFAULT '0000-00-00 00:00:00',
sHTML LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
tTimeStamp TIMESTAMP(0) DEFAULT '0000-00-00 00:00:00',
eType ENUM('All','Public','Private','Test') DEFAULT 'Test',
sImageName LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
bShowImage TINYINT(1) DEFAULT '-1',
INDEX `Date` (tDate),
PRIMARY KEY (iID)
)
Posted: Mon 14 Nov 2005 08:07
by Serious
We cannot reproduce your problem.
Please send us small test project if possible to reproduce the problem. Do not use third party components. If it is impossible for you to create test project please send us a piece of your code where the error occurs.
Specify where the error occurs, full exception message and call stack.
Small Project
Posted: Mon 14 Nov 2005 17:38
by bsd_01
I have sent you, via email, a small project.
I sent it to
[email protected]
Subject is: Forums - MySql Direct - Column 'Null' exceeds the MaxLength - Small Project ****Attention: Serious
Attached file: Test2.zip
Did you receive the small project?
Posted: Wed 16 Nov 2005 19:09
by bsd_01
Have you figured anything out?
Posted: Thu 17 Nov 2005 10:33
by Serious
We sent you an e-mail already. Here is its contents:
We think this behavior is caused by MySQL 4.1. This server passes incorrect
metadata to client so MySqlDataTable base level throws an exception. In
MySql 5.0 this problem is absent.
We advice you use DataSet instead of MySqlDataTable:
Code: Select all
DataSet ds = new DataSet();
MySqlDataAdapter adapter = new MySqlDataAdapter("describe dept",
connection);
adapter.Fill(ds);