you could try this work around. http://stackoverflow.com/questions/5498033/how-to-write-utf-8-characters-using-bulk-insert-in-sql-server
On Thu, Apr 11, 2013 at 5:53 PM, Rick Root <rick.r...@gmail.com> wrote: > > On Tue, Mar 26, 2013 at 11:10 PM, Paul Hastings <p...@sustainablegis.com > >wrote: > > > > > > SQL Server 2005 does not support UTF-8 apparently. > > > > sure it does. > > > > No, it doesn't. Not really. > > http://msdn.microsoft.com/en-us/library/bb330962(v=sql.90).aspx > > I'm loading this data from UTF-8 encoded files coming from an SAP system, > and I'm loading them using the BULK INSERT command. > > Even SQL Server 2012 doesn't support UTF-8. Look at this page ( > http://msdn.microsoft.com/en-us/library/ms188365.aspx) and find "UTF-8") > > Ultimately, my "workaround" here is that I found the specific garbage > strings after loading the data and replacing them with a sql udf I wrote > that basically does this: > > set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(163),'"') > set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(165),'"') > set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(214),'''') > set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(244),'-') > set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(201),'-') > > Rick > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355361 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm