unicode in c#

[Guy Brom]

Hi all,

I'm about to start a price-comparison service in c# (asp.net) that will
gather lots of
multilingual content and store it on a centralized database, to be displayed
later on a webpage.

Some of my sources are in Arabic, some in English, others in Chinese.

What's the best way to store the content on mssql2k? Obviouslly I need to
use nvarchar, but should I encode all 1-byte-per-symbol characters into its
unicode (2-bytes) character? If so, is there a function that does this?

I'll appriciate any insight on this!

[Daniel O'Connell [C# MVP]]

"Guy Brom" <gu******@yahoo.com> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...

Hi all,

I'm about to start a price-comparison service in c# (asp.net) that will
gather lots of
multilingual content and store it on a centralized database, to be
displayed
later on a webpage.

Some of my sources are in Arabic, some in English, others in Chinese.

What's the best way to store the content on mssql2k? Obviouslly I need to
use nvarchar, but should I encode all 1-byte-per-symbol characters into
its
unicode (2-bytes) character? If so, is there a function that does this?

A string in .NET is unicode internally. As long as you load the string
correctly from whatever source, then the ADO.NET layer should handle
everything for you.

If you mean in more general terms, outside of .NET, I would suggest posting
on a sql server group instead of here. The sql server groups will likely
have people who are well versed in the issues and can provide you some help.
I'll appriciate any insight on this!

[Jon Skeet [C# MVP]]

Guy Brom <gu******@yahoo.com> wrote:

I'm about to start a price-comparison service in c# (asp.net) that will
gather lots of
multilingual content and store it on a centralized database, to be displayed
later on a webpage.

Some of my sources are in Arabic, some in English, others in Chinese.

What's the best way to store the content on mssql2k? Obviouslly I need to
use nvarchar, but should I encode all 1-byte-per-symbol characters into its
unicode (2-bytes) character? If so, is there a function that does this?

I'll appriciate any insight on this!

If you're using nvarchar, then from the C# side it will just be
strings, which are unicode naturally. You shouldn't need to do any
encoding or decoding yourself.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too