Struts上传问题，请高手帮忙，谢谢！
我有一个系统，原来是在MySql下，能实现上传，后来我转换成SqlServer2000,就不能上传了，为什么？
MySql中表的定义如下：
1
CREATE TABLE `admin` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`ZH` varchar(20) NOT NULL,
`PASSWORD` varchar(15) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2
CREATE TABLE `client` (
`ZH` varchar(20) NOT NULL,
`UPASSWORD` varchar(15) NOT NULL,
`XM` varchar(40) default NULL,
`XB` varchar(4) default NULL,
`MAIL` varchar(50) default NULL,
`PHONE` varchar(20) default NULL,
`QQ` varchar(15) default NULL,
`DESCRIPTION` varchar(100) default NULL,
`IFPUBLIC` int(11) NOT NULL,
PRIMARY KEY (`ZH`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3
CREATE TABLE `clientfile` (
`ZH` varchar(20) NOT NULL,
`FILENAME` varchar(100) NOT NULL,
`FILESIZE` float NOT NULL,
`UPLOADTIME` datetime NOT NULL,
`IFPUBLIC` int(10) unsigned default NULL,
PRIMARY KEY (`ZH`,`FILENAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4
CREATE TABLE `clientfilespace` (
`ZH` varchar(20) NOT NULL,
`FILESPACE` float NOT NULL,
`FILEEXIST` float NOT NULL,
`FILECOUNT` int(10) unsigned NOT NULL,
PRIMARY KEY (`ZH`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
5
CREATE TABLE `clientmessage` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`ZH` varchar(20) NOT NULL,
`FRIENDZH` varchar(20) NOT NULL,
`CONTENT` varchar(100) NOT NULL,
`SENDTIME` datetime default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
6
CREATE TABLE `clientremind` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`ZH` varchar(20) NOT NULL,
`THEME` varchar(20) NOT NULL,
`CONTENT` varchar(100) NOT NULL,
`MAKEDATE` datetime default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
－－－－－－－－－－－
SqlServer2000
1
CREATE TABLE [dbo].[admin] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[ZH] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[PASSWORD] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
2
CREATE TABLE [dbo].[client] (
[ZH] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[UPASSWORD] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[XM] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[XB] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[MAIL] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[PHONE] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[QQ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[DESCRIPTION] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[IFPUBLIC] [bit] NOT NULL
) ON [PRIMARY]
GO
3
CREATE TABLE [dbo].[clientfile] (
[ZH] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FILENAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FILESIZE] [float] NOT NULL ,
[UPLOADTIME] [datetime] NOT NULL ,
[IFPUBLIC] [bit] NULL
) ON [PRIMARY]
GO
4
CREATE TABLE [dbo].[clientfilespace] (
[ZH] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FILESPACE] [float] NOT NULL ,
[FILEEXIST] [float] NOT NULL ,
[FILECOUNT] [int] NOT NULL
) ON [PRIMARY]
GO
5
CREATE TABLE [dbo].[clientmessage] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[ZH] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FRIENDZH] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[CONTENT] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SENDTIME] [datetime] NULL
) ON [PRIMARY]
GO
6
CREATE TABLE [dbo].[clientremind] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[ZH] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[THEME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[CONTENT] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[MAKEDATE] [datetime] NULL
) ON [PRIMARY]
GO
－－－－－－－－－－－－－－－－
是不是我在SqlServer2000中定义的表和MySql中的不一样呀？请高手帮忙。
[解决办法]
在 MYSQL中的一些字段 是在MS SQL中是没有的 LZ 自己检查下```
实在不行 把MYSQL的建表语句拿到MS SQL上运行，能运行代表没问题
