Spical charater issue after importing the data

• Simha24

  SSCommitted

  Points: 1984

  More actions

  November 24, 2011 at 3:40 am

  #260476

  Dear Team,

  I use to pick the data from one of my database (ex:ProductionDB) in CSV format. This data will be uploaded to another database (ex: ReportingDB).

  In this senario :

  i am getting speical charater from ProdcutionDB

  Ex: ' ProductSample (Here special charater is ( ' --SingleQuotes)) where as this SingleQutes is getting apper as Æ ProductSample ( Æ) in ReportingDB.

  I have followed following

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

  1. Both DB's collation levels are same

  2. For a temp solution we are replced by using Replace

  Kindly provide Permanent solution for this

  Thanks in advance.

• Simha24

  SSCommitted

  Points: 1984

  More actions

  November 25, 2011 at 2:03 am

  #1412891

  We got permanent solution for this

  Ans : Use CODEPAGE = ACP. to resolve.

  Desc :

  ACP

  Columns of char, varchar, or text data type are converted from the ANSI/Microsoft Windows code page (ISO 1252) to the SQL Server code page.

  Ref article :http://msdn.microsoft.com/en-us/library/ms188365.aspx