MySQL Forums
Forum List  »  Install & Repo

problems with large text in command prompt in xp
Posted by: Fizlar
Date: September 01, 2004 02:31PM

help help!!!

this has everyone stumped on other boards...

i have this table


CREATE TABLE NEWS (
ARTICLE_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
SUMMARY VARCHAR (75) DEFAULT 'UNKNOWN',
NEWS_ARTICLE LONGTEXT,
ARTICLE_DATE DATE,
AUTHOR_ID INT UNSIGNED NOT NULL,
PRIMARY KEY (ARTICLE_ID),
FOREIGN KEY (AUTHOR_ID) REFERENCES AUTHORS
);


and when i type

this in mysql

INSERT INTO NEWS
(SUMMARY, NEWS_ARTICLE, ARTICLE_DATE, AUTHOR_ID)
VALUES (’Bolton boss Sam Allardyce was delighted with his side win over Liverpool.’, ’Kevin Davies first half goal was enough to give the Trotters their third win of the season to lift them to third spot in the Premiership table. Im delighted for the players. Liverpool had an extra day than us pl [I ONLY GET THIS FAR]



very annoying

i have chaged the variable max packet size but no effect

it still does the same why?

using version 4.1 alpha ... is this a bug?

Options: ReplyQuote


Subject
Written By
Posted
problems with large text in command prompt in xp
September 01, 2004 02:31PM


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.