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

Double Byte Character Support?

I have a Point of Sale System which uses SQL (MSDE or SQL
2000) as the back end database. We have a client that
wants to buy a Chinese version of the Point of Sale
System...so my question is, does SQL 2000 or MSDE support
the double byte character set? Is there anything special I
need to do to accomplish this, or is there a special
version of SQL to buy?Hi Ray
SQL Server supports double byte character sets ("unicode")
Types NCHAR, NVARCHAR NTEXT are unicode (double byte)
Types CHAR, VARCHAR, TEXT are single byte.
There are also collations which cover language character sets & sort orders
as well.
This applies to all editions of SQL Server.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Ray" <rkano@.adctech.com> wrote in message
news:0f9601c38dfc$b9366290$a001280a@.phx.gbl...
> I have a Point of Sale System which uses SQL (MSDE or SQL
> 2000) as the back end database. We have a client that
> wants to buy a Chinese version of the Point of Sale
> System...so my question is, does SQL 2000 or MSDE support
> the double byte character set? Is there anything special I
> need to do to accomplish this, or is there a special
> version of SQL to buy?