MySQL Forums
Forum List  »  Delphi

could not insert data into "mediumtext" field
Posted by: tashi tobgay
Date: May 25, 2010 03:39AM

this is my mysql query,

INSERT INTO tbl_content( CONTENT_CATEGORY_ID, CONTENT_SECTION_ID, TITLE, INTROTEXT, FULLTEXT, CREATED) VALUES( "2", "6","tryyyyy", "jkl;jkl", "adsf", "asdfgg" );

but its not inserting data into the field "INTROTEXT" and "FULLTEXT" and both of these fields are of "mediumtext" datatype.


and here is my create table query,

CREATE TABLE `tbl_content` (
`CONTENT_ID` int(11) NOT NULL AUTO_INCREMENT,
`CONTENT_CATEGORY_ID` int(11) NOT NULL,
`CONTENT_SECTION_ID` int(11) NOT NULL,
`TITLE` varchar(255) collate latin1_general_ci NOT NULL,
`INTROTEXT` mediumtext NOT NULL,
`FULLTEXT` mediumtext NOT NULL,
`CREATED` datetime NOT NULL,
`CREATED_BY` varchar(255) collate latin1_general_ci NOT NULL,
`MODIFIED` datetime NOT NULL,
`MODIFIED_BY` varchar(255) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`CONTENT_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

...

anything wrong with it?

Options: ReplyQuote


Subject
Written By
Posted
could not insert data into "mediumtext" field
May 25, 2010 03:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.