At 8:45 PM +0200 7/8/99, Davor Cengija wrote:
> I'm creating a table:
>
>mysql> create table hr_vijesti (
> id mediumint unsigned primary key auto_increment,
> datum_unosenja timestamp,
> datum_odobravanja timestamp,
> naslov char(255) not null,
> nadnaslov text,
> podnaslov text,
> kategorija tinyint unsigned not null,
> kljucne_rijeci char(255) not null,
> autor char(64),
> izvor smallint unsigned not null,
> datum_stranica char(32),
> slika_naslov smallint unsigned,
> slika_body char(32),
> vezane_vijesti char(64),
> tekst mediumtext);
>Query OK, 0 rows affected (0.03 sec)
>
> after that i'm adding a column:
>
>mysql> alter table hr_vijesti add column upisao_u_bazu char(32);
>Query OK, 0 rows affected (0.04 sec)
>Records: 0 Duplicates: 0 Warnings: 0
>
> but all char column types are turned into varchar(xx) where xx
> is the number i've decided to use with char():
It's in the manual.
http://www.mysql.com/Manual_chapter/manual_Reference.html#Silent_column_changes
--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
