Chinese/Japanese characters in a table filed

Hi,
how should I go about designing my database (table, field, collate) if
I'd like it to support chinese, japanese and other non-english
characters?
I can't find any articles or best practises!
MortenAlthough Japan and China still have many computers with their own encodings
(e.g. JIS, GB, Big 5).
Any Windows computer will use Unicode and thus you can use nvarchar() or
nchar()
For general background...http://www.unicode.org/
more specifically try
http://msdn.microsoft.com/library/d...LServer2000.htm
"hansiman" <hansi@.hotmail.com> wrote in message
news:6ud861hpcistq3jfer9167fmor02j9f9nr@.
4ax.com...
> Hi,
> how should I go about designing my database (table, field, collate) if
> I'd like it to support chinese, japanese and other non-english
> characters?
> I can't find any articles or best practises!
> Morten