euro symbol not replicating properly from oracle to sqlserver

[siddu]

Hi,

I have a problem regarding euro symbol (?) replication from Oracle to
SQLserver2005. At oracle side we have a column containing ? (euro symbol).
which is being replicated to sql server. The select statment for that column
displays that symbol as (?) question mark. The column at oracle is
varchar(512) and at sqlserver side is nvarchar(512)

I tried to view the column with various collations, but in vain.
select column1 collate Latin1_General_CI_AS from table1
select column1 collate Latin1_General_CI_AS_WS from table1
.
.
.

whereas I can insert the ? (euro symbol) and view it through select
statement on the same table.

Can experts throw light on this.

I think the conversion while bcp is not proper. Any ideas ?

Thanks in Advance.

[siddu]

Here too euro symbol is appearing as question mark.

"siddu" <revan...@rediff.com> wrote in message
news:efd9pxS...@TK2MSFTNGP05.phx.gbl...

[siddu]

Many Thanks Dan, for your reply.

I did a replication from Sql server to Sql server for the table containing
Euro sign which works fine. The symbol is replicated and can be seen through
select stmt.

So I am now suspecting that some conversion happens when the .bcp file is
created. But I am not getting
literature on how the bcp file is created. which sproc does this and what
parameters influence the bcp.

Can you throw light on it.

Thanks,

Siddu

"siddu" <revan...@rediff.com> wrote in message

news:OxyNU1S...@TK2MSFTNGP05.phx.gbl...