Home > Archive > Certified Internet Webmaster - CIW > March 2004 > SQL server for foreign language web site





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author SQL server for foreign language web site
C S

2002-08-15, 8:23 am

Can I confirm something with everyone - a client would like to create a
chinese web site and store chinese characters in SQL Server (english
edition). Are there any problems with this?

Also, are there any special settings that should be noted before creating
the database - eg locale, data type, etc?

Much appreciated


linda deng[MS]

2002-10-05, 9:48 pm

Hi Cs,

There is no problem when you perform this operation. However, please make
sure that the data type is created as Unicode type. For example, when we
create a table with a column which wants to store some character strings,
the data type generally is char or varchar. Each character in these string
data will occupy one byte storage space. For these national characters such
as Chinese, we should create the column's data type as nchar or nvarchar.
Each character in these string data will take two bytes storage space. For
more information on Unicode, please refer to Microsoft SQL Server Books
Online.

You can perform a simple test on your SQL Server before applying into the
production environment.

Sincerely,

Linda Deng
Microsoft Support Engineer

This posting is provided "AS IS" with no warranties, and confers no rights.

Tai Yee [MS]

2002-10-05, 9:48 pm

For additional information on Unicode and using the International features
in SQL Server, see the following white paper on MSDN:

http://msdn.microsoft.com/library/d...-us/dnsql2k/htm
l/intlfeaturesinsqlserver2000.asp

Here is the Summary:
This article introduces Microsoft SQL Server developers to the international
features of SQL Server 2000. Topics covered include an explanation of
Unicode, SQL Server international data types, and key issues regarding
implementation.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.


"linda deng[MS]" <lideng@online.microsoft.com> wrote in message
news:5XNhwSSRCHA.2392@cpmsftngxa06...
> Hi Cs,
>
> There is no problem when you perform this operation. However, please make
> sure that the data type is created as Unicode type. For example, when we
> create a table with a column which wants to store some character strings,
> the data type generally is char or varchar. Each character in these string
> data will occupy one byte storage space. For these national characters

such
> as Chinese, we should create the column's data type as nchar or nvarchar.
> Each character in these string data will take two bytes storage space. For
> more information on Unicode, please refer to Microsoft SQL Server Books
> Online.
>
> You can perform a simple test on your SQL Server before applying into the
> production environment.
>
> Sincerely,
>
> Linda Deng
> Microsoft Support Engineer
>
> This posting is provided "AS IS" with no warranties, and confers no

rights.
>



C S

2002-10-05, 9:49 pm

Hi Tai Yee and Linda Deng

Thanks very much for your useful input. It will come in great use
"Tai Yee [MS]" <taiyee@online.microsoft.com> wrote in message
news:Odwg99URCHA.1632@tkmsftngp11...
> For additional information on Unicode and using the International features
> in SQL Server, see the following white paper on MSDN:
>
>

http://msdn.microsoft.com/library/d...-us/dnsql2k/htm
> l/intlfeaturesinsqlserver2000.asp
>
> Here is the Summary:
> This article introduces Microsoft SQL Server developers to the

international
> features of SQL Server 2000. Topics covered include an explanation of
> Unicode, SQL Server international data types, and key issues regarding
> implementation.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no

rights.
> Please do not send email directly to this alias. This alias is for

newsgroup
> purposes only.
>
>
> "linda deng[MS]" <lideng@online.microsoft.com> wrote in message
> news:5XNhwSSRCHA.2392@cpmsftngxa06...
> > Hi Cs,
> >
> > There is no problem when you perform this operation. However, please

make
> > sure that the data type is created as Unicode type. For example, when we
> > create a table with a column which wants to store some character

strings,
> > the data type generally is char or varchar. Each character in these

string
> > data will occupy one byte storage space. For these national characters

> such
> > as Chinese, we should create the column's data type as nchar or

nvarchar.
> > Each character in these string data will take two bytes storage space.

For
> > more information on Unicode, please refer to Microsoft SQL Server Books
> > Online.
> >
> > You can perform a simple test on your SQL Server before applying into

the
> > production environment.
> >
> > Sincerely,
> >
> > Linda Deng
> > Microsoft Support Engineer
> >
> > This posting is provided "AS IS" with no warranties, and confers no

> rights.
> >

>
>



Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2010 examnotes.net