Roman, Thursday, January 24, 2002, 2:36:45 PM, you wrote:
RZ> i create table from script: RZ> create table if not exists msg00m1 ( RZ> id int primary key auto_increment, RZ> hid int not null, RZ> dsg char(10) not null, RZ> nt char(7) not null, RZ> gn char(2) not null, RZ> wot char(12) not null, RZ> k char(19) not null, RZ> k2 varchar(20) not null, RZ> wwt char(2) not null, RZ> drt char(10) not null, RZ> cr char(13) not null, RZ> cr2 varchar(14) not null, RZ> wat char(15) not null, RZ> wat2 varchar(16) not null, RZ> w char(3) not null RZ> ); RZ> and command desc msg00m1 shows: mysql>> desc msg00m1; RZ> +-------+-------------+------+-----+---------+----------------+ RZ> | Field | Type | Null | Key | Default | Extra | RZ> +-------+-------------+------+-----+---------+----------------+ RZ> | id | int(11) | | PRI | NULL | auto_increment | RZ> | hid | int(11) | | | 0 | | RZ> | dsg | varchar(10) | | | | | RZ> | nt | varchar(7) | | | | | RZ> | gn | char(2) | | | | | RZ> | wot | varchar(12) | | | | | RZ> | k | varchar(19) | | | | | RZ> | k2 | varchar(20) | | | | | RZ> | wwt | char(2) | | | | | RZ> | drt | varchar(10) | | | | | RZ> | cr | varchar(13) | | | | | RZ> | cr2 | varchar(14) | | | | | RZ> | wat | varchar(15) | | | | | RZ> | wat2 | varchar(16) | | | | | RZ> | w | char(3) | | | | | RZ> +-------+-------------+------+-----+---------+----------------+ RZ> 15 rows in set (0.00 sec) RZ> some columns (dsg, nt, wot, k, drt, cr, wat) declared as char in script are RZ> varchar in database... RZ> whats is going on? Please check the manual at: http://www.mysql.com/doc/S/i/Silent_column_changes.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
