Re: Alter table problem

2002-06-18 Thread Heikki Tuuri
Heikki Tuuri" <[EMAIL PROTECTED]> Sent: Wednesday, June 19, 2002 12:37 AM Subject: Re: Alter table problem > > Ferdek, > > > > what character set you have specified in my.cnf? I tested your script with > > latin1 (the default) and 3.23.52, and it seemed to work witho

Re: Alter table problem

2002-06-18 Thread Heikki Tuuri
Ferdek, what character set you have specified in my.cnf? I tested your script with latin1 (the default) and 3.23.52, and it seemed to work without errors. For example, for the table reklamacja you see below it created the 3 foreign key constraints. Can you provide a simple repeatable test case

Alter table problem

2002-06-18 Thread Ferdek
Hello everybody ! I just give up. Can somebody tell me, what I do wrong ? Here is script: CREATE DATABASE servcontrol; USE servcontrol; CREATE TABLE czesc ( id_czesci CHAR(100) NOT NULL, id_hurtowni TINYINT UNSIGNED NOT NULL, id_nazwy INT UNSIGNED NOT NULL, dokument SMALLINT UNSIGNED N