Bug #25898 Default Value to Text Fields

• Submitted: 28 Jan 2007 12:26
• Modified: 30 Jan 2007 7:03
• Reporter: jim theodoropoulos
• Status: Not a Bug
• Category: MySQL Server: Data Types
• Severity: S1 (Critical)
• Version: 5.0.27
• OS: Windows (windows)
• CPU Architecture: Any

[28 Jan 2007 12:26] jim theodoropoulos

Description:
When i create a table with create table and set default to a TEXT field I have an error "No default value to TEXT/BLOB type fields"

But to 5.0.20 I used until now i can set default values to Text fields. 

How to repeat:
CREATE TABLE t1 (
  `p01` int(11) NOT NULL auto_increment,
  `p02` int(11) NOT NULL default '0',
  `p30` text NOT NULL default ''
  PRIMARY KEY  (`p01`)
) ENGINE=InnoDB DEFAULT CHARSET=greek;

Suggested fix:
To be possible to set default values to Text fileds (as character)

[29 Jan 2007 10:16] Sveta Smirnova

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Please see at http://dev.mysql.com/doc/refman/5.0/en/blob.html what blob and text columns can not have default value.

[30 Jan 2007 7:03] jim theodoropoulos

Thanks for your reply. 
I have seen the page you send me. 
But When using versions until 5.00.22 i can set Default Values to Text Fields. 

Because i have write a lot of code using default values to Text Fields (i set them NOT NULL) is there any way to set default values or i must change my code?