SQL Server Forums - Unicode data transformation using DTS

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Unicode data transformation using DTS

New Topic

Reply to Topic

Printer Friendly

Author

Topic

vanamaa
Starting Member

India
2 Posts

Posted - 03/19/2012 : 11:53:20

Hi Team,

I have got one requirement like copying unicode data from sql server to sybase using dts. What i did was by using table mapping/column mapping from source to destination. But unicode data is not copying properly in sybase table. Can you please suggest me on this.

Thanks

visakh16
Very Important crosS Applying yaK Herder

India
47159 Posts

Posted - 03/19/2012 : 15:58:19

what corresponding datatype you've chosen in db2?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

vanamaa
Starting Member

India
2 Posts

Posted - 03/20/2012 : 03:26:09

quote:
Originally posted by visakh16

what corresponding datatype you've chosen in db2?

---------------------------------------------------------------------
It's not DB2.

Sybase.

In SQL it is nVarchar
In Sybase it is UniVarchar
---------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

visakh16
Very Important crosS Applying yaK Herder

India
47159 Posts

Posted - 03/20/2012 : 16:07:40

whats happening to data in sybase? its getting corrupted?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.06 seconds.