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 |
|
alexjamesbrown
Starting Member
48 Posts |
 Posted - 2009-01-28 : 06:02:10
|
| Hi,I have a bulk insert:BULK INSERT TableName FROM '"+@PathFileName+"' WITH (FIELDTERMINATOR = '|', TABLOCK, DATAFILETYPE='char')(part of a stored proc - @PathFileName is a param..When i run it, it works fine, however all words with apostrophe - such as "It's" come out ItÆsÆ? where did that come from!?Any ideas how i can solve this...? |
|
|
AvanthaSiriwardana
Yak Posting Veteran
78 Posts |
Posted - 2009-01-28 : 06:12:34
|
| Did you try to replace that apostrophe with the relavant sign like we convert whatever the sysmbols is XML ??eg:- "&" with "&"Avantha Siriwardana |
 |
|
|
|
|
|
Bulk Insert - Apostrophe problem...