I was under the impression that varchar2(1000) in Oracle would only allocate space for the 2 chararcters and was wondering if varchar in SQL Server is handled the same way.

I'm working with a <B>very</B> large DB in MS SQL 2000. All char fields are defined ... However, each and every reference I have seen insists that using varchar fields for Kanji could result ...