I get this error when I issue this command:
describe events
events is my table name
Any Ideas?
Column 'Null' exceeds the MaxLength
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)
)
.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)
)
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.
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
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
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?
Have you figured anything out?
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:
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);