Dear all, I have asp.net 2.0 web page program. Now I need to make chinese which can insert into mssql database 2000 and show up in the web page after save. Inserting is using sqldatasource. insertcommand="insert into table1 (custname, custaddress) values (N@custname, N@custaddr )" Is it correct if with changing the table1 fields to be nvarchar? But I have tried and failed. Please help.
Dear all, I have solved by inserting the below statement into <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> "Raymond Chiu" wrote in message news:OUzkLc5zIHA.2408@TK2MSFTNGP04.phx.gbl... > Dear all, > > I have asp.net 2.0 web page program. > Now I need to make chinese which can insert into mssql database 2000 and > show up in the web page after save. Inserting is using sqldatasource. > > insertcommand="insert into table1 (custname, custaddress) values > (N@custname, N@custaddr )" > > Is it correct if with changing the table1 fields to be nvarchar? > > But I have tried and failed. > Please help. >
You display Chinese characters using iso-8859-1 !?? Serge. http://www.apptranslator.com - Localization tool for your C++applications "Raymond Chiu" wrote in message news:egJx9zC0IHA.872@TK2MSFTNGP04.phx.gbl... > Dear all, > > I have solved by inserting the below statement into <head> > > <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> > > "Raymond Chiu" wrote in message > news:OUzkLc5zIHA.2408@TK2MSFTNGP04.phx.gbl... >> Dear all, >> >> I have asp.net 2.0 web page program. >> Now I need to make chinese which can insert into mssql database 2000 and >> show up in the web page after save. Inserting is using sqldatasource. >> >> insertcommand="insert into table1 (custname, custaddress) values >> (N@custname, N@custaddr )" >> >> Is it correct if with changing the table1 fields to be nvarchar? >> >> But I have tried and failed. >> Please help. >> > >