MySQL Forums
Forum List  »  Docs

Specifying text type length
Posted by: Mark Farmer
Date: March 21, 2010 09:07PM

Newbie question, but one I can't find an answer for anywhere:

I don't seem to be able to specify a length for the 'text' type in MySQL - I can't seem to specify a length using the phpmyadmin interface, nor by using a SQL statement.

Is it even possible to specify a length for this? I thought specifying field lengths was a best practice. Does the 'text' type auto-truncate or something like that, rendering specifying the length superfluous? Or am I missing something?

Thanks for the help.

Options: ReplyQuote


Subject
Views
Written By
Posted
Specifying text type length
6642
March 21, 2010 09:07PM
2681
July 29, 2010 03:37AM


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.