Chinese chars in SQL?

We have a need to enter and store Chinese characters in a SQL Server table.
Has anyone done this before?
We're using ASP .NET to program entry forms, so they'd have to accept
Chinese chars, the data would be stored in SQL Server, and then search
results would have to display Chinese as well.
What additional technology might we need to implement this?
Thanks!!As far as I know you may use datatype as NVarchar / Nchar.
Even if the datatype the column is Varchar / Char it should still be able to save it, provided you take care of it in UI i.e. ASP page using code-page setting.|||You would need to store data as Unicode (i.e. nvarchar) and select the
approriate Chinese collation for your data. You need to also make sure that
your application is ready to process Chinese (or other) data:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html/vxorilocalizationplanning.asp
--
Michiel Wories, SQL Server PM
This posting is provided "AS IS" with no warranties, and confers no rights.
--
"Dean J. Garrett" <deanj_garrett@.yahoo.com> wrote in message
news:Ojae0LPmDHA.372@.TK2MSFTNGP11.phx.gbl...
> We have a need to enter and store Chinese characters in a SQL Server
table.
> Has anyone done this before?
> We're using ASP .NET to program entry forms, so they'd have to accept
> Chinese chars, the data would be stored in SQL Server, and then search
> results would have to display Chinese as well.
> What additional technology might we need to implement this?
> Thanks!!
>
>|||Thank you! I'll follow your advice.
"Michiel Wories [MS]" <mwories@.online.microsoft.com> wrote in message
news:3f97f365$1@.news.microsoft.com...
> You would need to store data as Unicode (i.e. nvarchar) and select the
> approriate Chinese collation for your data. You need to also make sure
that
> your application is ready to process Chinese (or other) data:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html
/vxorilocalizationplanning.asp
> --
> Michiel Wories, SQL Server PM
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> --
> "Dean J. Garrett" <deanj_garrett@.yahoo.com> wrote in message
> news:Ojae0LPmDHA.372@.TK2MSFTNGP11.phx.gbl...
> > We have a need to enter and store Chinese characters in a SQL Server
> table.
> > Has anyone done this before?
> >
> > We're using ASP .NET to program entry forms, so they'd have to accept
> > Chinese chars, the data would be stored in SQL Server, and then search
> > results would have to display Chinese as well.
> >
> > What additional technology might we need to implement this?
> >
> > Thanks!!
> >
> >
> >
>