SELECT @@serviceName serviceName, @@version as version,
SERVERPROPERTY('productversion') productVersion,
SERVERPROPERTY ('productlevel') productLevel,
SERVERPROPERTY ('edition') edition,
SERVERPROPERTY ('collation') collation
serviceName version productVersion productLevel edition collation
MSSQLSERVER Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
8.00.2039 SP4 Enterprise Edition SQL_Latin1_General_CP1_CI_AS
(1 row(s) affected)

Hi Rmiao:

1. not quite sure about what you mentioned "if they are in the same code page"

2. our current collation is SQL_Latin1_General_CP1_CI_AS, we have not use nchar, nvarchar, nor ntext in 99% of our table columns datatype.

Does it mean, we need to "Replace all uses of the char, varchar, and text data types with nchar, nvarchar, and ntext. This eliminates the need to consider code page conversion issues.".

3. Have not dealed with another language before....

thanks for your help
David