|
Home > Archive > MS SQL Server > November 2006 > upgrade a sql 7 database with big5 codepage to sql 2005
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
upgrade a sql 7 database with big5 codepage to sql 2005
|
|
|
| Hi,
I want to upgrade a sql 7 database with BIG5 codepage to sql 2005 and
have the following questions.
1) When I install the SQL 2005, what sorting order do I need to choose?
2) Does the upgrade wizard convert the BIG5 data (in trandition
Chinese) into unicode? How should I instruct the wizard to convert the
data stored in the database to unicode? How should I instruct the
wizard NOT to convert the data?
3) What will happen to the nvarchar data type used in the database?
Thanks,
AH
| |
| John Bell 2006-11-09, 5:16 am |
| Hi
If your database is restored from SQL 7 onto a SQL 2005 it will try and use
the same or the nearest collation to what is currently being used. Your
nvarchar data should not be affected. You may want to try and run the latest
version of the upgrade advisor against your current system to check out
compatibility.
John
"AH" wrote:
> Hi,
>
> I want to upgrade a sql 7 database with BIG5 codepage to sql 2005 and
> have the following questions.
>
> 1) When I install the SQL 2005, what sorting order do I need to choose?
>
> 2) Does the upgrade wizard convert the BIG5 data (in trandition
> Chinese) into unicode? How should I instruct the wizard to convert the
> data stored in the database to unicode? How should I instruct the
> wizard NOT to convert the data?
>
> 3) What will happen to the nvarchar data type used in the database?
>
> Thanks,
> AH
>
>
|
|
|
|
|