Are you using INSERT query in the DTS? If yes, then have you been using "N" with UNICODE string in the INSERT Statement like

INSERT INTO MyTable (ColA, UnicodeColB)
VALUES ('Value for ColA', N'Unicode Value for ColB')

You need to specify explicitly if the string contains unicode chars in SQL Server.

--- On Sun, 5/25/08, goshen couture <goshen_couture@...> wrote:
From: goshen couture <goshen_couture@...>
Subject: Re: [firebird-support] Replicate Firebird 2.0 (using charset unicode_fss) to MS SQL 2000
To: firebird-support@yahoogroups.com
Date: Sunday, May 25, 2008, 11:07 PM











Hi Thomas,



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



Regards,

Halim S



Thomas Steinmaurer <ts@iblogmanager. com> 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]





























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