In SQL Server 2000, you can have collation set at the column level, so each column could be different. You can set a default for the db and change it for any table or column.
If you are going to set it for Chinese, be sure you have someone who can read the data when you are troubleshooting