Hi Thomas,

yes i did set the charset as UNICODe_FSS at the ODBC connection setup

Regards,
Halim S

Thomas Steinmaurer <ts@...> wrote: > 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





---------------------------------
Expand your social network today - Yahoo! Singapore Search.

[Non-text portions of this message have been removed]