Posted by oliver on 02/26/07 15:26

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

[Back to original message]