You are here: Re: nvarchar & varchar « MsSQL Server « IT news, forums, messages
Re: nvarchar & varchar

Posted by Michael on 02/26/07 16:40

On Feb 26, 10:26 am, "oliver" <oraus...@hotmail.com> wrote:
> On 26 Feb, 15:13, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote:
>
> > The nvarchar data type provides support for Unicode characters. This is
> > needed if you are building an international system that must store different
> > languages. However, if you have no need to store Unicode characters then you
> > are better using varchar. The nvarchar data type occupies twice the space of
> > varchar as it uses 2 bytes to encode each character.
>
> > HTH,
>
> > Plamen Ratchevhttp://www.SQLStudio.com
>
> varchar will support a lot of characters from different languages
> though (depending on the collation codepage) so no need to rush into
> doubling your storage if you dont "really" need to

Plamen, Oliver Thanks a lot!

Mike

 

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

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