Column 'Null' exceeds the MaxLength

Column 'Null' exceeds the MaxLength

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

Postby Serious » Mon 14 Nov 2005 06:23

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

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

Postby 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.
Serious
 

Small Project

Postby 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?

Postby bsd_01 » Wed 16 Nov 2005 19:09

Have you figured anything out?
bsd_01
 
Posts: 7
Joined: Tue 04 Oct 2005 03:47

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


Return to dotConnect for MySQL