text too large?

[Stijn Goris]

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

[Sharif Tanvir Karim]

"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

[Matthias Gutfeldt]

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

[Stijn Goris]

"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