Re: TEXT lenght
| From: | Doug Semig | Date: | Mon, 17 Jul 2000 20:51:46 +0000 |
| Subject: | Re: TEXT lenght | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-1214@lists.php.net to get a copy of this message | ||
Typically, in an RDBMS that supports a "text" extension type, you probably
don't need the "(20)". There is only one place to look for the absolute
answer, and that's the manual for your RDBMS.
Doug
Sharif Islam was heard at 03:31 PM 7/17/00 -0500 to say:
>
>I am getting error for this:
>CREATE TABLE table_name ( id INT NOT NULL AUTO_INCREMENT, first TEXT(20),
>last VARCHAR(20), phone VARCHAR(20), PRIMARY KEY(id) );
>
>
>Is it legitimate to assign a field length when using data type TEXT?
>
>It seems to be the problem here.
>
>Thanks in advance
>
>-Sharif