should i use nvarchar or varchar

[TechBoyJK]

If I'm using a standard US install of Microsoft Server 2000, will people of foreign territories be able to enter data using their language set? Im thinking no, and i need people to be able to enter data from many different languages...

I know nvarchar takes up double the space, and im trying really hard to be smart about table size, but I wanted to see if anybody knows of better logic....

I am surfing google too.

 

[MrChad]

If you need to support foreign languages and double-byte character sets at all, use nvarchar.

 

[TechBoyJK]

thanks, i guess I will