List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 8 1999 7:24pm
Subject:Re: varchar inserted instead of char?!
View as plain text  
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/
Thread
varchar inserted instead of char?!Davor Cengija8 Jul
  • Re: varchar inserted instead of char?!Paul DuBois8 Jul
  • Re: varchar inserted instead of char?!Sasha Pachev8 Jul