Re: NULL value in VARCHAR fields SOLVED

2001-05-06 Thread stefan mojschewitsch
hi list, thanx for answering my question. i recompiled mysql with CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS and now it works for me. special thx to Shankar, who declared my problem in better words than mine and to Paul for knowing all from mysqlDocu. ttfn stefan -- st3V13h nach diktat verreist

Re: NULL value in VARCHAR fields

2001-05-03 Thread stefan mojschewitsch
to be rejected, and insert into tel set tel='+49 815 4711', service=1,iuser=USER(); accepted. ttfn stefan and to make the listFilter happy :-) database,sql,query > > On Thu, 3 May 2001, stefan mojschewitsch wrote: > > > using DEFAULT USER(), would be nice, b

Re: NULL value in VARCHAR fields

2001-05-03 Thread stefan mojschewitsch
[EMAIL PROTECTED] wrote: > > Stefan, > > When you insert a row in a table and you do not specify a value > for a field, mySQL (and any other DBMNS?) will do the following: > > 1. If field accepts null: it will set the value of that field > to null > > 2. If field DOES NOT accept null - no defa

NULL value in VARCHAR fields

2001-05-03 Thread stefan mojschewitsch
hi list, sorry for posting again, i will learn it. i have a problem with DEFAULT NULL value in a varchar field. mysql is version 3.23.33. i want to have an user field in a row, to see who has created the row. create table minidb.tel ( id int UNSIGNED NOT NULL AUTO_

NULL value in VARCHAR fields

2001-05-03 Thread stefan mojschewitsch
hi list, i have a problem with DEFAULT NULL value in a varchar field. mysql is version 3.23.33. i want to have an user field in a row, to see who has created the row. create table minidb.tel ( id int UNSIGNED NOT NULL AUTO_INCREMENT, tel char(16)