You are here: Re: Multilingual Table « MsSQL Server « IT news, forums, messages
Re: Multilingual Table

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация