FreeTDS Development Group

[ananthbv AT gmail.com]

Just to make sure, the 'price' column in the table has euro symbol.

On Wed, Dec 29, 2010 at 7:47 PM,  <ananthbv AT gmail.com> wrote:
> Hi,
>
> I am trying to freebcp out data from a table Sybase and freebcp it in
> to a SQL Server table. The FreeTDS installed is on a Linux box
>
> Some of the data contain a euro symbol. The output file of freebcp
> shows the euro symbol as '~@'. When that data is loaded into the table
> with freebcp in, it is failing with the error
>
> Starting copy...
> Msg 20088, Level 3
> I/O error while writing bcp error file
>
> The error file (passed as -e parameter to the freebcp in command shows
> the row (and mentions the column number) which has the euro symbol.
>
> The table definition is as below:
>
> CREATE TABLE dbo.tmpreq
> (
>   id       int           NOT NULL,
>   price    varchar(20)   NULL
> )
>
> On the SQL Server side, I tried making the varchar column a nvarchar
> column. The freebcp in worked, but the euro symbol was replaced with a
> '?'.
>
> Could someone please advise what I should do to get the freebcp
> working? Is there a char set setting somewhere?
>
> sp_helpsort on sybase shows iso_1 and the same command on SQL Server
> says Latin1-General.
>
> I also tried one more thing. From my windows desktop, i did a sybase
> bcp out with -J iso_1 and did a sql server bcp in with -C RAW. With
> this, i was able to load all rows sucessfully with the euro symbol
> intact. But since I'll have to run the data load from unix scripts, I
> cant use windows commands.
>
> Some other details:
> FreeTDS version: 0.82-1
> Sybase: 12.5
> SQL Server: 2008 R2
>
>
> Thanks.
>