I have a developer that needs to store different language
characters in a table. What he is doing is designing a web
page, so that someone will have a choice as what language
he will view the web page in. Is it possible to store lets
say Russian or Chinese characters in a SQL Server table?
Does this fall under Unicode data? If you can do this, how
do you get the characters into the coulmns? Any help or
suggestions would be greatly appreciated!!Hello Richard !
Yes, this is UNICODE. How you get the data into the columns ? With an INSERT
? Regardless , your business logic
is on SQL Server or in the frontend, the data is send to SQL Server in
UNICODE and also stored there as this.
Jens Süßmeyer.
"Richard" <richard.peoples@.lacdc.org> schrieb im Newsbeitrag
news:034301c365ce$cce23130$a501280a@.phx.gbl...
> I have a developer that needs to store different language
> characters in a table. What he is doing is designing a web
> page, so that someone will have a choice as what language
> he will view the web page in. Is it possible to store lets
> say Russian or Chinese characters in a SQL Server table?
> Does this fall under Unicode data? If you can do this, how
> do you get the characters into the coulmns? Any help or
> suggestions would be greatly appreciated!!|||Obviously then, I need to have SQL Server installed as Unicode. Correct?
>--Original Message--
>Hello Richard !
>Yes, this is UNICODE. How you get the data into the columns ? With an INSERT
>? Regardless , your business logic
> is on SQL Server or in the frontend, the data is send to SQL Server in
>UNICODE and also stored there as this.
>Jens S=FC=DFmeyer.
>
>"Richard" <richard.peoples@.lacdc.org> schrieb im Newsbeitrag
>news:034301c365ce$cce23130$a501280a@.phx.gbl...
>> I have a developer that needs to store different language
>> characters in a table. What he is doing is designing a web
>> page, so that someone will have a choice as what language
>> he will view the web page in. Is it possible to store lets
>> say Russian or Chinese characters in a SQL Server table?
>> Does this fall under Unicode data? If you can do this, how
>> do you get the characters into the coulmns? Any help or
>> suggestions would be greatly appreciated!!
>
>.
>|||No just change the columns you have to NVARCHAR to store UNICODE. But
remeber --> The Maximum Length will be chopped to 4000 characters.
Jens Süßmeyer.
No comments:
Post a Comment