Column 'Null' exceeds the MaxLength

[bsd_01]

I get this error when I issue this command:

describe events


events is my table name

Any Ideas?

[Serious]

Specify .NET Framework, MySQL, MySQLDirect .NET and OS version.
Include definition for 'events' table.

[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)
)

[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.

[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

[bsd_01]

Have you figured anything out?

[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);