Re: I can't create varchar smaller than 4 in mysql.
| From: | Jason G. | Date: | Thu, 08 Nov 2001 09:25:26 +0000 |
| Subject: | Re: I can't create varchar smaller than 4 in mysql. | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-14130@lists.php.net to get a copy of this message | ||
Look at "Silent Column change spec" on mysql.com. Varchar will only go so small before it is converted to char. varchar takes an extra byte to say how long it is, and when you get down to 2 bytes, that does not make sense.
-Jason Garber
IonZoft.com
At 11:06 PM 11/7/2001 +0100, Pierre-Alain Joye wrote:
Why do 'est_id', 'bloco', 'estado' and 'ddd' are char if they are to be varchar? By default mysql will not mix char and varchar in the same table. Check the doc for more infos to force one type instead another. pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net