> 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 MS SQL 2000 Data Transformation Service to move data from
> Firebird to MS SQL 2000.
>
> after i move my data from Firebird 2 (consists of UNICODE_FSS for
> chinese character) to MS SQL 2000(english version), the records shows
> strange character instead of chinese character ?

What access technology do you use with DTS and Firebird?

Perhaps you have to provide the UNICODE_FSS character set in your
ODBC/ADO/... connection?


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com