In SQL server char will allocate the full size specified even if not filled.<BR>varchar will allocate the smallest space using single byte language characters.<BR>nvarchar is the same as varchar ...

I'm working with a very large DB in MS SQL 2000. All char fields are defined as varchar. Now, I am trying to add support for Kanji, in particular, and later Spanish, German, and eventually ...