SQL Server - replicating euro symbol from oracle to sqlserver

Asked By siddu

20-Nov-09 07:04 AM

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

20-Nov-09 07:44 AM

Collation only affects the character set for non-Unicode columns.  The euro
symbol can be stored correctly in nvarchar, as you noted and and also in the
Latin1_General_CI_AS non-Unicode columns.


So you are importing data from a flat file using BCP?  BCP defaults to code
page 850, which knows nothing about the euro symbol.  Try using the BCP -C
option to specify the code page that matches the file (e.g. 1252) or specify
RAW to prevent code page conversion entirely.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

27-Nov-09 03:10 PM

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

27-Nov-09 08:51 AM

So you are creating the file using BCP?  Try specifying the codepage RAW or
1252 using the /C parameter like the example below.   This and the other BCP
options are listed in the SQL Server Books Online.

BCP tempdb.dbo.foo out foo.txt /S MyServer /c /T -C RAW

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/