I can't create varchar smaller than 4 in mysql.
| From: | Bruno Gimenes Pereti | Date: | Wed, 07 Nov 2001 19:15:49 +0000 |
| Subject: | I can't create varchar smaller than 4 in mysql. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14117@lists.php.net to get a copy of this message | ||
Today is the day of the problems...
I'm doing the following:
# mysql -p vest2002n1 < vest2002n1.sql (I'll attach this file)
and I get:
mysql> desc candidatos;
+-----------+---------------------+------+-----+------------+---------------
-+
| Field | Type | Null | Key | Default | Extra
|
+-----------+---------------------+------+-----+------------+---------------
-+
| cod | int(6) unsigned | | PRI | NULL | auto_increment
|
| nome | varchar(36) | | | |
|
| opc1 | tinyint(2) unsigned | | | 0 |
|
| opc2 | tinyint(2) unsigned | YES | | NULL |
|
| id_idioma | tinyint(1) unsigned | | | 0 |
|
| id_sexo | tinyint(1) unsigned | | | 0 |
|
| nasc | date | | | 0000-00-00 |
|
| num_id | varchar(11) | | | |
|
| org_id | varchar(6) | | | |
|
| est_id | char(2) | | | |
|
| endereco | varchar(26) | | | |
|
| numero | varchar(5) | YES | | NULL |
|
| bloco | char(3) | YES | | NULL |
|
| apto | varchar(4) | YES | | NULL |
|
| bairro | varchar(17) | YES | | NULL |
|
| cep | varchar(9) | | | |
|
| cidade | varchar(21) | | | |
|
| estado | char(2) | | | |
|
| ddd | char(2) | YES | | NULL |
|
| telefone | varchar(8) | YES | | NULL |
|
| ip | varchar(15) | | | |
|
| proxy | varchar(15) | YES | | NULL |
|
| pg | char(1) | YES | | NULL |
|
+-----------+---------------------+------+-----+------------+---------------
-+
Why do 'est_id', 'bloco', 'estado' and 'ddd' are char if
they are to be
varchar?
Thank's,
Bruno Gimenes Pereti.