By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,047 Members | 1,257 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,047 IT Pros & Developers. It's quick & easy.

text too large?

P: n/a
hi all,

My problem: when inserting a large text (from a textarea) into the database
it just wont happen. When the text is somewhat smaller no problem occurs.
The large text is about 100 lines * 60 characters (not that big at all). The
field I insert is a TEXT type so that couldn't be the problem.

Someone can help me out?

kind regards
Stijn
Jul 17 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Stijn Goris" <me*****@hotmail.com> wrote in message
news:Ho*********************@phobos.telenet-ops.be...
hi all,

My problem: when inserting a large text (from a textarea) into the database it just wont happen. When the text is somewhat smaller no problem occurs.
The large text is about 100 lines * 60 characters (not that big at all). The field I insert is a TEXT type so that couldn't be the problem.

Someone can help me out?

kind regards
Stijn


What exactly is your problem? After inserting the text, is it cutoff at a
certain point in the database? The length of the TEXT field in the database
is also important, make sure there isn't a specified length.
--
Sharif Tanvir Karim
http://www.onlyonxbox.net
Jul 17 '05 #2

P: n/a
Stijn Goris wrote:
hi all,

My problem: when inserting a large text (from a textarea) into the database
it just wont happen. When the text is somewhat smaller no problem occurs.
The large text is about 100 lines * 60 characters (not that big at all). The
field I insert is a TEXT type so that couldn't be the problem.


Which database are you using?
What error messages do you get from the database?

What's the maximum length of a TEXT column type in the database you're
using? In MySQL it's "a maximum length of 65535 (2^16 - 1) characters"
according to <http://www.mysql.com/doc/en/Column_types.html>.
Matthias

Jul 17 '05 #3

P: n/a

"Stijn Goris" <me*****@hotmail.com> wrote in message
news:Ho*********************@phobos.telenet-ops.be...
hi all,

My problem: when inserting a large text (from a textarea) into the database it just wont happen. When the text is somewhat smaller no problem occurs.
The large text is about 100 lines * 60 characters (not that big at all). The field I insert is a TEXT type so that couldn't be the problem.

Someone can help me out?

kind regards
Stijn


addslash() did the job. Query was blokked when ' was read
Jul 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.