I'm gonna try to get the SAP people to send me a UTF-16 file instead (essentially the same as the link except I wouldn't have to convert it :) )
On Thu, Apr 11, 2013 at 1:03 PM, Russ Michaels <r...@michaels.me.uk> wrote: > > 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:355363 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm