Hi guys,

I'm using Firebird 2.0 database, some of the table fields are using charset
UNICODE_FSS because it consists of chinese characters.
I want to replicate data from Firebird 2.0 to MS SQL 2000.
I use Data Transformation Service to move data from Firebird to MS SQL 2000.

However, after i replicate my Firebird data to MS SQL 2000, all the chinese
character UNICODE_FSS charset display as strange character

I have change the regional option to chinese(PRC) but still MS SQL 2000
didnt show the correct chinese character.

According to Firebird, MS SQL 2000 nvarchar datatype is compatible with
Firebird UNICODE_FSS:
http://www.firebirdsql.org/manual/mi...ata-types.html

I have install ms sql 2000 service pack 4 also but still didnt display the
chinese character.

Please Advise.

Thanks!
Regards,
Halim S