double-byte

I have a question concerning sql server handling of languages such as
Chinese that require double-byte unicode. We will be using C# to code the
strings, so this should be handled automatically. Is there anything that
needs to be done with SQL Server to handle these languages?Hi Bill
You may want to check out
http://msdn2.microsoft.com/en-us/library/bb330962.aspx
http://msdn2.microsoft.com/en-us/library/ms143503.aspx
http://support.microsoft.com/kb/917398
and
http://msdn2.microsoft.com/en-us/library/ms143508.aspx
John
"Bill Fuller" wrote:
> I have a question concerning sql server handling of languages such as
> Chinese that require double-byte unicode. We will be using C# to code the
> strings, so this should be handled automatically. Is there anything that
> needs to be done with SQL Server to handle these languages?
>
>|||Make sure to use nvarchar data types in SQL Server to store Unicode. Also
prefix any strings in T-SQL statements (such as insert and update) with the
N character:
insert into mytable (id, mynvarchar_column) values (1, N'Unicode
string')
HTH
Karl Gram
"Bill Fuller" <someone@.nospam.com> wrote in message
news:OoxXiil$HHA.536@.TK2MSFTNGP06.phx.gbl...
>I have a question concerning sql server handling of languages such as
>Chinese that require double-byte unicode. We will be using C# to code the
>strings, so this should be handled automatically. Is there anything that
>needs to be done with SQL Server to handle these languages?
>