Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Mysql to Sql Server 2000

Author  Topic 

saeeds
Starting Member

1 Post

Posted - 2004-12-05 : 03:54:19
Hi...
I transfer my data from Mysql database to sql server....
I do it transfer with DTS in sql server....
I use adodb and switch my database easily..
but my unicode data not shown correctly on my site... Why?
data transfer completed successfully and data in mysql exactly same with sql server data...
where is the problem?
please help me....

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-12-05 : 07:29:15
Hi there

Are you SQL Server columns nvarchar / ntext or varchar / text ?
You need the "n" ones for unicode.


Damian
Go to Top of Page
   

- Advertisement -