Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

From ASCII into MSSQL database .... UTF8 ?

Hi all,

We are using SAP ID Mgmt 7.1 SP5 on Windows x64 server and MSSQL2005 database.


We create a csv file from Microsoft Excel and Saved as CSV (default encoded ANSI)

We upload the file on the server

We read the file from an administration job with Pass FromASCII


Accentuate caracters are not readed correctly and are replaced by "?"

Ex CSV file:



in temp table:

Firstname Lastname

C?cile DeFrance

If I convert the csv file into UTF8 without BOM (using Notepad++), it works !!! But it's not acceptable to convert file each time I need mass import.

We never met this issue when running on Oracle. Do you guys have some tricks for me ?



Edited by: Benjamin Gourdon on Jun 9, 2011 6:47 PM

Not what you were looking for? View more on this topic or Ask a question