• 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,



    Monday, September 03, 2007 10:31 AM

All replies


    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,

    Tuesday, September 04, 2007 12:12 AM

    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.


    Tuesday, September 04, 2007 1:04 AM

    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,

    Tuesday, September 04, 2007 4:51 AM
  • 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.

    Tuesday, September 04, 2007 1:55 PM