Re: (ot) SQL bulk inserts, ftps, and unicode special characters

2013-04-12 Thread Rick Root
Thanks Paul. It occurs to me that even If I put the data in correctly, I still have to deal with it because I can't really output a utf-16 character to a web page (or can I?).. I dunno maybe it just works. time to play... ~|

Re: (ot) SQL bulk inserts, ftps, and unicode special characters

2013-04-12 Thread Paul Hastings
On 4/13/2013 1:55 AM, Rick Root wrote: It occurs to me that even If I put the data in correctly, I still have to deal with it because I can't really output a utf-16 character to a web page (or can I?).. I dunno maybe it just works. no, it will show up fine (your db driver cf will see to

Re: (ot) SQL bulk inserts, ftps, and unicode special characters

2013-04-11 Thread Rick Root
On Tue, Mar 26, 2013 at 11:10 PM, Paul Hastings p...@sustainablegis.comwrote: 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

Re: (ot) SQL bulk inserts, ftps, and unicode special characters

2013-04-11 Thread Russ Michaels
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:

Re: (ot) SQL bulk inserts, ftps, and unicode special characters

2013-04-11 Thread Rick Root
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.

Re: (ot) SQL bulk inserts, ftps, and unicode special characters

2013-04-11 Thread Paul Hastings
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

(ot) SQL bulk inserts, ftps, and unicode special characters

2013-03-26 Thread Rick Root
Hi all, I am getting some data feeds from our SAP system (god help me). Some of the data contains unicode characters apparently like em dashes and such. For example, take the following string: AMEX – ADR Box The em dash seems to come through in my text file is 3 characters when I view it in

Re: (ot) SQL bulk inserts, ftps, and unicode special characters

2013-03-26 Thread Rick Root
Sorry, the em dash is 915-199-244, not 915-244-71. a unicode em dash is unicode 2015 .. I'm not sure how these numbers relate though On Tue, Mar 26, 2013 at 4:08 PM, Rick Root rick.r...@gmail.com wrote: Hi all, I am getting some data feeds from our SAP system (god help me). Some of

Re: (ot) SQL bulk inserts, ftps, and unicode special characters

2013-03-26 Thread Paul Hastings
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