MySQL Forums :: General :: Text(1024)


Advanced Search

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) Vector Thorn 04/03/2011 02:54AM
Re: Text(1024) laptop alias 04/03/2011 08:06AM
Re: Text(1024) Vector Thorn 04/03/2011 08:10AM
Re: Text(1024) laptop alias 04/03/2011 08:21AM
Re: Text(1024) Vector Thorn 04/03/2011 08:25AM
Re: Text(1024) Rick James 04/03/2011 05:21PM
Re: Text(1024) Vector Thorn 04/03/2011 05:30PM
Re: Text(1024) Rick James 04/03/2011 07:45PM
Re: Text(1024) Vector Thorn 04/03/2011 08:00PM
Re: Text(1024) Rick James 04/03/2011 09:04PM
Re: Text(1024) Vector Thorn 04/03/2011 09:17PM
Re: Text(1024) Rick James 04/03/2011 10:29PM
Re: Text(1024) Sabine Marek 04/04/2011 02:23AM
Re: Text(1024) Vector Thorn 04/04/2011 02:28AM
Re: Text(1024) laptop alias 04/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.