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