Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
pushp82
Yak Posting Veteran
83 Posts |
Posted - 2014-07-01 : 02:26:46
|
Hi,I uploads a excel to sql server 2008R2 using BULK INSERT. It is working fine but the issue comes when some special characters comes in data like "Fumé",,"Tarapacá", when this type of words inserts into table called TBL_TEMP becomes "FumT","Tarapacß".I don't want this to be like this but as it is as it in excel.My column is nvarchar and collation of database and table column is "SQL_Latin1_General_CP1_CI_AS". I'm also using this column for fulltext index search.I tried to find out some solution on google but failed. Pls helpThanks, |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-07-01 : 05:39:13
|
Whioh collation are you using for the BULK INSERT statement? Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
pushp82
Yak Posting Veteran
83 Posts |
Posted - 2014-07-03 : 08:31:10
|
well your question gave me answer I tried CODEPAGE = 'ACP' and it got resolved. Thanks for asking |
|
|
|
|
|