BIG5 to BG IN SQL SERVER DATABASE

Hi Everyone,

I want to convert my database from BIG5 TO BG, but i don't know how i do, could you teach me to do it ?

Thank you very much,

Oliver

Please help me , i trust here that somebody can help me , so, Microsoft always told me, if you have any difficult questions ,please come here , you will find saitisfy answer,

Thank you very much,

|||

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.

http://msdn2.microsoft.com/en-us/library/ms180175.aspx

|||

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,

Thanks again,

|||

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.