Data Porting

• Ajit Kumar

  Grasshopper

  Points: 16

  More actions

  February 25, 2009 at 7:09 am

  #200697

  I'm using bcp utility to port data from text file to sql 2005 table, which is running fine but the data in the table is not exactly the same as in the text file

  e.g

  Mytext.txt MyTable ('Name')

  ----------------------- --------------------------

  1° Miglior Prezzo 1° Miglior Prezzo

  2M Criação Editorial 2M Criação Editorial

  AB29 Vermögensverwaltung AB29 Vermögensverwaltung

  When I use query analyzer to Insert/update, the content is correct. What setting I have to do to run bcp correctly

• VastSQL

  SSC-Dedicated

  Points: 36278

  More actions

  March 12, 2009 at 4:28 am

  #958163

  Check your database collation settings.