BIG5 is this collation in SQL Server Chinese_PRC_CI_AS
BG is this collation in SQL Server Chinese_Taiwan_Stroke_CI_AS
So you have to create a package that is moving data from Chinese_PRC_CI_AS collation using Nvarchar/Nvarchar (max) as relational engine data types to a new database using Chinese_Taiwan_Stroke_CI_AS collation. The link below is a list of most collations in SQL Server. Hope this helps.
Thank you very much, but this is not my want,
Maybe my discription is not clear,
Now, I have a database of MRP ,but it is BIG5 type that is trandation chinese, but i want to convert it to simple chinese, because we don't want to use BIG5 any more,
Now, i don't have a good idea to convert it to GB, i can only export talbe from SQL Server 2000 then convert it with some tools, but under this way, i need to spend a lot of times, so ,i want to look for a simple way to convert it,
What is MRP? I gave you both traditional Chinese and Simplified Chinese collations for SQL Server 2005. If you are doing translation you need a separate tool for that, but you still need the simplified Chinese collation for your destination database, Tables and columns in SQL Server 2000.