Hi

I havn't really used it but I would guess that while the DBs can handle
Unicode fine the 'MS SQL 2000 Data Transformation Service' either does
not handle Unicode or is not configured to do so.

I would check there first.

--
Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Halim Setiyawan wrote:

> 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 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 ?
>
> I have change the regional option to chinese(PRC) but still MS SQL
> 2000 didnt show the correct chinese character.
>
> According to your Firebird data, MS SQL 2000 nvarchar datatype is
> compatible with Firebird UNICODE_FSS:
> http://www.firebirdsql.org/manual/migration-mssql-data-types.html
>
> Please Advise Thanks!
> Regards,
> Halim S
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>