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.