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.
| Author |
Topic |
|
senthilkumarrs
Starting Member
2 Posts |
 Posted - 2003-07-17 : 10:53:17
|
| Hi,I am facing problem while transferring the data from Oracle 8 to SQL server 2000. All the migrated chinese messages are looks like junk in SQL server.But in the MS SQL DB level I am using chinese collation.Did anyone know what should do to solve this problem?The DTS runs soomthly. But the chinese charactors are converted into some junk. I know I am missing somthing. I donot know what is that.I am using the Chinese collation in the MS SQL Server 2000 and in the table I am storing the chinese charator in the nvarchar filed. But when I transferring the data from oracle to Sql server 2000, the chinese charator are converted into junk after the transfer. I used the column as varchar & nvarchar in the SQl server. Both having the same results.In the DTS itself if I preview source (Oracle 8i) the table it shows like this. But if open the SQL plus and it shows differently.Using the Oracle ODBC driver 8.01.06.00 dated 27.01.2000 and SQL Server ODBC Driver ( 2000.20.528.00) dated 24.09.2001Please help meThanks Regardskumar |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-07-17 : 17:50:04
|
| If you connect to Oracle using the ODBC driver (say you use Access and link a table), does it look correct? Could the driver/driver settings be the problem? |
 |
|
|
senthilkumarrs
Starting Member
2 Posts |
Posted - 2003-07-17 : 21:07:25
|
| In the DTS If I do the privew the column that contains the chinese values shows as junk.May be the (ORACLE)driver is not supporting the Chinese charactors. ?? |
|
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2003-07-17 : 22:02:41
|
| Hi, DTS allows you to set the collation to be used to perform the transfer. Try to set it to use Source collation instead of dest Collation. Also, try to use OLE DB instead ODBC and/or uncheck the perform OEM/ANSI translation on ODBC or Auto Transaltion in the advanced button for Data sources.Sérgio Monteiro |
|
|
|
|
|
|
DTS to transfer from Oracle 8 to MS SQL server