BCP Operation with Currency Codes

• Bajrang

  SSCrazy

  Points: 2074

  More actions

  October 14, 2009 at 2:34 pm

  #210959

  Hello all,

  I am doing BCP Out operation out of a sql table on SQL Server 2005. I have two columns in the table; which are currency codes columns.

  Curr_Code varchar(1)

  Curr_Code_Euro varchar(1)

  I am outputting file in to CSV file.

  everything is fine except Currency columns:

  for "£" i am getting "œ" and for "€" I am getting "_" in the output

  declare @sql as varchar(1000)

  set @sql = 'bcp "select * from test_rjp" queryout "\j-serv-01\vg\temp\test.csv" -c -t, -Usa -P abcde'

  exec master..xp_cmdshell @sql

  Can somebody help please??

  Thx,

  -RP

  -RP

• sql_lock

  SSCrazy Eights

  Points: 9375

  More actions

  October 15, 2009 at 9:14 am

  #1066334

  Try using "-C" (uppercase) and defining your database/Column collation.

• Bajrang

  SSCrazy

  Points: 2074

  More actions

  October 16, 2009 at 12:45 pm

  #1067117

  Thanks a lot... it solved my issue right away.

  -RP

  -RP

• balde

  SSCommitted

  Points: 1594

  More actions

  November 8, 2010 at 5:45 am

  #1247602

  ...Thanks; just resolved my issue too, appended a "...-C RAW" statement to the bcp command syntax;

  SET @bcpCommand = 'bcp "EXEC <SP> ''' + @batchID + ''', 1" queryout "' + @sFileSpec1 + '" -t"," -c -T -C RAW'