Page 1 of 1
mysql TEXT type
Posted: Tue Mar 29, 2005 6:21 am
by pelegk2
i am updating :
Code: Select all
UPDATE dep_list='1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,24,25,26,'
WHERE user_id=35
i recive only :
Code: Select all
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,
why is that?
thnaks i nadvance
peleg
Posted: Tue Mar 29, 2005 8:47 am
by feyd
post an export of the table structure. (SQL format)
here it is
Posted: Tue Mar 29, 2005 9:09 am
by pelegk2
Code: Select all
CREATE TABLE /*!32300 IF NOT EXISTS*/ users (
user_id tinyint(3) unsigned NOT NULL auto_increment,
user_name varchar(10) ,
user_name_heb varchar(30) ,
user_pass varchar(10) ,
firm_list varchar(20) ,
level enum('1','0') NOT NULL DEFAULT '1' ,
is_mankal enum('1','0') DEFAULT '0' ,
is_hashav enum('1','0') DEFAULT '0' ,
dep_list text ,
signature varchar(20) ,
tel varchar(12) ,
tools varchar(50) ,
invoice_access enum('1','0') DEFAULT '0' ,
PRIMARY KEY (user_id),
UNIQUE user_id (user_id),
INDEX user_id_2 (user_id)
);
Posted: Tue Mar 29, 2005 9:32 am
by feyd
are you absolutely sure you're getting up to that? Post an export version (INSERT ...) of that record please.