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

Question

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.

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 this collation.
I am new for this sql server.
Please help me out from this issue?

Answer 1

in the management studio --> right click on the table --> generate script --> it will show you the create table script which includes the collation you are using.

---

Please mark the post as answered to help others to choose the best.
chandra sekhar pathivada | www.calsql.com (SQL Server Community Website)