[wp-trac] [WordPress Trac] #10377: Problem in comments!

[WordPress Trac]

#10377: Problem in comments!
---------------------------+------------------------------------------------
 Reporter:  muriloazevedo  |       Owner:                          
     Type:  defect (bug)   |      Status:  new                     
 Priority:  normal         |   Milestone:  Future Release          
Component:  Comments       |     Version:  2.8                     
 Severity:  normal         |    Keywords:  'sql exception' comments
---------------------------+------------------------------------------------
Changes (by dd32):

  * milestone:  Unassigned => Future Release


Comment:

 > The solution is simple, use the property maxlenght in the tag <input />
 e limit the characters if will be send to database.

 That doesnt stop people from directly posting the data anyway..

 The comment_content field is a TEXT field:

 {{{
 BLOB
 TEXT
 A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1)
 characters. See section 7.7.1 Silent column specification changes.
 MEDIUMBLOB
 MEDIUMTEXT
 A BLOB or TEXT column with a maximum length of 16777215 (2^24 - 1)
 characters. See section 7.7.1 Silent column specification changes.
 LONGBLOB
 LONGTEXT
 A BLOB or TEXT column with a maximum length of 4294967295 (2^32 - 1)
 characters. See section 7.7.1 Silent column specification changes.
 }}}

 so theres a limit of 65,535 characters in a comment at present.. Perhaps
 the comment handler should throw a error upon a longer comment.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/10377#comment:1>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software