Column 'Null' exceeds the MaxLength

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
bsd_01
Posts: 7
Joined: Tue 04 Oct 2005 03:47

Column 'Null' exceeds the MaxLength

Post by bsd_01 » Sat 12 Nov 2005 19:33

I get this error when I issue this command:

describe events


events is my table name

Any Ideas?

Serious

Post by Serious » Mon 14 Nov 2005 06:23

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

bsd_01
Posts: 7
Joined: Tue 04 Oct 2005 03:47

Post by bsd_01 » Mon 14 Nov 2005 07:49

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

Post by Serious » Mon 14 Nov 2005 08:07

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
Posts: 7
Joined: Tue 04 Oct 2005 03:47

Small Project

Post by bsd_01 » Mon 14 Nov 2005 17:38

I have sent you, via email, a small project.

I sent it to support@crlab.com

Subject is: Forums - MySql Direct - Column 'Null' exceeds the MaxLength - Small Project ****Attention: Serious

Attached file: Test2.zip

bsd_01
Posts: 7
Joined: Tue 04 Oct 2005 03:47

Did you receive the small project?

Post by bsd_01 » Wed 16 Nov 2005 19:09

Have you figured anything out?

Serious

Post by Serious » Thu 17 Nov 2005 10:33

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

Post Reply