How to create a database that can support multiple language ?

Hi:
Is it possible to create a database and tables which can store
multiple language ? I need to create a table with a column that can
accept English, Chinese, Japan. Korea and Thai word.
Thanks
JCVoon
yes.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"JC Voon" <jcvoon_99@.yahoo.com> wrote in message
news:42228b35.7044749@.msnews.microsoft.com...
> Hi:
> Is it possible to create a database and tables which can store
> multiple language ? I need to create a table with a column that can
> accept English, Chinese, Japan. Korea and Thai word.
> Thanks
> JCVoon
|||Wei Xiao :
Please tell me how...
Thanks
JCVoon

> Is it possible to create a database and tables which can store
> multiple language ? I need to create a table with a column that can
> accept English, Chinese, Japan. Korea and Thai word.
|||Unicode is easist choice if it works for you.
If you just need store and retrieve these strings as opaque binary objects,
then you can use binary.
These articles might help:
http://msdn.microsoft.com/library/de...ar_da_6ttf.asp
http://msdn.microsoft.com/library/de...es_04_6zp0.asp
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"JC Voon" <jcvoon_99@.yahoo.com> wrote in message
news:4225f10c.33116579@.msnews.microsoft.com...
> Wei Xiao :
> Please tell me how...
> Thanks
> JCVoon
>
|||wei xiao:
Thank for the reply.
I've declare the field to use NVarChar, and it work for me now.
Do i still need to consider the Collation setting in both field or
database level ?
Thanks
JCVoon

>Unicode is easist choice if it works for you.
>If you just need store and retrieve these strings as opaque binary objects,
>then you can use binary.
>These articles might help:
>http://msdn.microsoft.com/library/de...ar_da_6ttf.asp
>http://msdn.microsoft.com/library/de...es_04_6zp0.asp