Software
Microsoft
Apple
Hardware
Network
Shareware
Games Online
Live Scores - TV
Software FAQ
»
Database
»
MySQL Server
»
MYSQL : default value in TEXT or BLOB
MYSQL : default value in TEXT or BLOB
I need to set a default value for texts fields that are longer than 255 chars
I tried BLOB and TEXT and got a message:
"BLOB 'mailContent' cannot have a default value"
How can I achieve this ?
regards
Solution: MYSQL : default value in TEXT or BLOB
In text and in varchar you can not have default value and in varchar you have a 255 chars limit.
So you have to do a trick independed on what you programming.For example to give to a hidden label a default value that you will store to the field if a user does not type anything in the specific field.
Active
COGNOS Impromptu v7.4.3 - Export to XLS and CSV Issues
Scientific Notation Issue in Crystal Reports 9. 18 Digit number turned into Scientific Notation.
Business objects Crosstab
identifier 'V_CUR' must be declared
[Oracle][ODBC][Ora]Ora-009
42 Table or view does not exist (#942)
How to alter session parameters from within oracle forms?
Multi pass executions
jquery multiple file upload insert file name to mysql
Google Earth - can you move multiple placemarks in My Places to new folder at same time?
SAP: difference between Purchase Order (PO) and Purchasing Document
How to update LONG column in Oracle 9i
Putting Javascript in a Wordpress file (not a post) in the Body (not the head)
ETL for HL7 data into Microsoft SQL Server
browser not sending HTTP_REFERER headers to website
Problem: How can I disable the caching of EJB 3.0 datasources?
PHPmyadmin
Installation of Logitech WebCam software
Problem: Wildcard for datapump import
.bat file to copy zip and unzip files
XHTML: there is no attribute "name"
Crystal Lawson Report Error
Recover deleted vm esx
Net Stop /Net start command syntax
Using PHP on webserver, to retrieve a file from a remote PC with ftp server installed
Regarding Popen in python
SBS Shutting itself down! It says I have multiple domain controllers when I don't!
Sendmail seems to be relaying using localhost 127.0.0.1 to send mail out
Explanation of RSS
Text-Diff in RUBY
Problem: Mysql ODBC