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.
sql