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

Reply via email to