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:355358 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm