On 3/27/2013 3:08 AM, Rick Root wrote: > AMEX � ADR Box > > The em dash seems to come through in my text file is 3 characters when I > view it in notepad++
that's because your data is garbaged or its encoding is either missing or misidentified or i guess notepad++ doesn't understand unicode (not sure, not familiar w/it). UTF-whatever are variable width encodings of unicode. UTF encodes all of the million or so unicode code points as 1-4 bytes (8-bit). if something "bad" happens those encodings can "blow apart" & look like multiple chars. > However, when the data is loaded into SQL Server, it goes in as three > characters. unicode 915-199-71 how are you inserting the data? is the column holding this data unicode capable (for sql server it should be one of the "N" datatypes). > SQL Server 2005 does not support UTF-8 apparently. sure it does. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:355167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
