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?
>

doing transactions with linked server(ole db provider)

Hi all,

When i begin a distributed transaction..., do i need to always
set xact_abort on?

But when i tried to put custom error handling to roll back a transaction with a linked server , it seems its impossible (as set xact_abort on, already automatically rolls back the transaction)

Does anyone have any ideas on this?

Thanks in advance

Bennyset xact_abort on is not required for distributed transactions.|||But i get an error when i dont set that.
Do you know what has to be done instead?

Thanks for your feedback

Benny