FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Problem adding text to Longtext field





Shike
I keep getting this message

Quote:
Forbidden
You don't have permission to access /phpmyadmin/tbl_replace.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.


when trying to add text to a longtext field.

According to my Sam's teach yourself PHP, MySQL, and Apache... a longtext type has a max length of 4,294,967,295 characters. When I get the error the text in the field is 1,194 characters (including spaces) long. Now is the max length decided by the binary equivalent of the characters? or is it the actual character present?

I hope that my question is clear.
poppitz
Hi,

this is from the mysql reference manual (http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html):

Quote:
LONGTEXT [CHARACTER SET charset_name] [COLLATE collation_name]

A TEXT column with a maximum length of 4,294,967,295 or 4GB (232 1) characters. The maximum effective (permitted) length of LONGTEXT columns depends on the configured maximum packet size in the client/server protocol and available memory.


Maybe the length is defined shorter on your table.
Shike
poppitz wrote:
Hi,

this is from the mysql reference manual (http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html):

Quote:
LONGTEXT [CHARACTER SET charset_name] [COLLATE collation_name]

A TEXT column with a maximum length of 4,294,967,295 or 4GB (232 1) characters. The maximum effective (permitted) length of LONGTEXT columns depends on the configured maximum packet size in the client/server protocol and available memory.


Maybe the length is defined shorter on your table.


I didn't define it on my table, which lead me to believe that it would automaticaly set to max.
Related topics
Taiwan- China or U.S.
PHP: Feedback form issues.. help =P
2 suggestions
If you need help with php-nuke
Need Gimp Help
My Own Site (Finally Some Real Progress)
CGI FormMail Script Part II
Sugestion
Html quize. way over
Need someone to make a site for me - please
Funny with C code.
ImageMagick - How to add text?
counting the unique word frequencies
Injecting Text into a Text entry field
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.