Posted by Roy Harvey on 01/21/07 00:16

On 20 Jan 2007 12:06:16 -0800, "Denis" <k9kondop@hotmail.com> wrote:

>I wish to create a table in which field contents may be in any of the
>following languages: English, Greek and Chinese.
>
>Which architecture/structure do you suggest I use?
>
>Should I perhaps split this into 3 tables each one with different
>collations? Or would it be best to set the table to unicode? Or is
>there a better option you think?

Sounds like a perfect situation for UNICODE, a two-byte character set
that works with virtually any and everylanguage. Instead of char and
varchar, use Nchar and Nvarchar.

Roy Harvey
Beacon Falls, CT

[Back to original message]