none
BIG5 to BG IN SQL SERVER DATABASE

    Question

  • 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

    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.

     

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

    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