Junk arabic details while transfer arabic data from sql server 2000 to oracle

[noushk17]

We are facing problems to view arabic details in oracle which is transfered from sql server 2000.
In oracle database we are using charecterset is UTF8.
NLS_CHARACTERSET :UTF8 and NLS_NCHAR_CHARACTERSET:UTF8
Sqlr server collation is SQL_Latin1_General_CP1256_CI_AS.
we are using stored procedure for transfering data from sql server 2000 to oracle.
And i am able to view some arbic details which is not transfered from sql server 2000.

I thing some configuration i need to change in sql server.


Can any one help me out from this issue?

[rmiao]

If you change collation on sql, you may unable to see arabic in sql server. It's not sql configure issue but collation difference between two rdbms.

[noushk17]

We were using to import from another intermediate sqlserver and it was successfull.
And more over i cannot change anything in oracle database which is live.
The issue is we are using one intermediate sqlserver for transfering the data to oracle apart from main sqlserver.
now we want to stop the intermediate and need to transfer from main sqlserver to oracle Db.

Main sql server and intermediate have the same collation.

i am calling stored procedure using Operating system command.

It was working with intermediate server


It might be the problem of collation.
because thats the one I did additionally in main sql server.

The collation of main sql server was SQL_Latin1_General_CP1_CI_AS

And i have changed to SQL_Latin1_General_CP1256_CI_AS using this scommand sqlservr -m -T4022 -T3659 -q"SQL_Latin1_General_CP1256_CI_AS" which i run through command prompt.
It might be the way which i used to change the collation is wrong.

How can i check the collation in object level and database level.

What should i have to do for changing thiscollation.
Please guid me. and I am new for this sql server.

[rmiao]

You can check it in object properties page in ssms.