On 4/11/2013 11:53 PM, Rick Root wrote: > No, it doesn't. Not really. > > http://msdn.microsoft.com/en-us/library/bb330962(v=sql.90).aspx
actually that page and a decade of my experience says it does. UTF-8 will get transformed (its designed for that) to UCS2 by the db driver. for all practical purposes, sql server does "support" utf-8 encoded text. BULK INSERT is another matter. UTF-8 was dropped from that particular tool for some reason or another (digging around it looks like maybe a bug that was supposed to be fixed in 2 months, 5 years ago). ms uses the term "Unicode Character Format" for what BULK INSERT supports but they're the only one that does. not exactly sure what's meant by it but reading thru this page: http://msdn.microsoft.com/en-us/library/ms188289.aspx the BOM mentioned there seems to indicate its UTF-16. so i think you're on the right track w/trying to get UTF-16 out of your source & using the wide char option. because its ms, i'd try to get little endian UTF-16 to be on the safe side. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:355372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
