MySQL Forums
Forum List  »  General

Text(1024)
Posted by: Vector Thorn
Date: April 03, 2011 02:54AM

Hey guys, i was wondering something. I usually limit most small text fields to tinytext for things like comments; however i have a need to enlarge that to allow for larger --more in-depth-- comments, and concluded that the best size would be 1024, as that would allow for a lengthy comment/reply, and wouldn't really waste so much space.

The issue is, mysql's text types jump from 255 straight to 65536 (or something like that). Is there any way to limit a text column to 1024 characters, internally, to reduce storage size?

premium domain names that i'm selling

Options: ReplyQuote


Subject
Written By
Posted
Text(1024)
April 03, 2011 02:54AM
April 03, 2011 08:06AM
April 03, 2011 08:10AM
April 03, 2011 08:21AM
April 03, 2011 08:25AM
April 03, 2011 05:21PM
April 03, 2011 05:30PM
April 03, 2011 07:45PM
April 03, 2011 08:00PM
April 03, 2011 09:04PM
April 03, 2011 09:17PM
April 03, 2011 10:29PM
April 04, 2011 02:23AM
April 04, 2011 02:28AM
April 04, 2011 02:42AM


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.