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

CF8 CFFTP FTPS/Implicit SSL connection?

2008-02-19 Thread James Blaha
Hi All, Does anyone know if you can use cfftp in CF8 to make a FTPS/Implicit SSL connection? I can make cfftp SFTP/SSH connections just fine. My guess is I’m connecting to a remote IIS FTP server that’s using a SSL cert. Regards, Jim

Re: FTPS

2007-07-19 Thread Jake Pilgrim
I too would still be interested in finding any code which gracefully handles FTPS transactions. The current solution I'm looking at would require me to write a BAT file for every transaction I wish to perform... ~| Macromedia

Re: FTPS

2007-07-19 Thread Jake Pilgrim
The file transaction I'm looking to do is a communication with a bank - I have no control over the file server in place on their end. It is an FTPS fileserver, not an SFTP fileserver and I need to be able to access it programmatically. If there's an existing Java object that I can wrap

Re: FTPS

2007-07-18 Thread Christopher Hinkle
Adrian -- I'd be really interested in this CFX with FTPS capabilities... unfortunately the link you gave had an X-ed out email address. Could you provide more information? Perhaps off-list, if necessary? Thanks, chris. I used Drew's CFX - while you usually just read about it's SFTP

RE: FTPS

2007-07-18 Thread Adrian Wagner
Chris, I contacted Drew and gave him your email address. It's his work, so I left it to him to give it away. A. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, 19 July 2007 8:17 AM To: Adrian Wagner; CF-Talk; [EMAIL PROTECTED] Subject: Re: FTPS

Re: FTPS

2007-07-18 Thread Christopher Hinkle
Adrian -- Thanks much! chris. Chris, I contacted Drew and gave him your email address. It's his work, so I left it to him to give it away. A. Adrian -- I'd be really interested in this CFX with FTPS capabilities... unfortunately the link you gave had an X-ed out email address. Could you

RE: FTPS

2007-07-05 Thread Jim Rising
I think the original poster was looking for FTPS ... Not SFTP. The Jscape link in my prior post supports both, while jsch is strictly for SFTP via SSH. Jim Rising Sr. Cold Fusion Developer ICGLink Inc. www.icglink.com -Original Message- From: Mark Stanton [mailto:[EMAIL PROTECTED

Re: FTPS

2007-07-04 Thread Mark Stanton
://www.jcraft.com/jsch/ Jim Rising Sr. Cold Fusion Developer ICGLink Inc. www.icglink.com -Original Message- From: Jake Pilgrim [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 11:36 AM To: CF-Talk Subject: FTPS Does anyone know of a way I can connect to an FTPS (FTP over

FTPS

2007-07-03 Thread Jake Pilgrim
Does anyone know of a way I can connect to an FTPS (FTP over SSL) server using coldfusion? I have seen the sftp.cfc download out there, but SFTP is a different protocol and this CFC doesn't seem to work. I would prefer a CFC/custom tag based solution, but I am able to run cfexecute so

RE: FTPS

2007-07-03 Thread Jim Rising
:[EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 11:36 AM To: CF-Talk Subject: FTPS Does anyone know of a way I can connect to an FTPS (FTP over SSL) server using coldfusion? I have seen the sftp.cfc download out there, but SFTP is a different protocol and this CFC doesn't seem to work. I would

Re: FTPS

2007-07-03 Thread Judah McAuley
FTPS is not the same thing as SFTP. FTPS is ftp over SSL. It typically runs on port 990. SFTP is ftp running over SSH. It typically runs on port 22. I've seen differing support for the two protocols. Filezilla, for instance, support SFTP and FTPS on the client, but only supports SFTP

RE: FTPS

2007-07-03 Thread Jim Rising
03, 2007 4:19 PM To: CF-Talk Subject: RE: FTPS Or... You can use this: http://www.socialpoints.com/blog/client/index.cfm/2006/3/25/co ldfusion-sftp SFTP != FTPS Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized

RE: FTPS

2007-07-03 Thread Dave Watts
Or... You can use this: http://www.socialpoints.com/blog/client/index.cfm/2006/3/25/co ldfusion-sftp SFTP != FTPS Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC

RE: FTPS

2007-07-03 Thread Dan G. Switzer, II
I've seen differing support for the two protocols. Filezilla, for instance, support SFTP and FTPS on the client, but only supports SFTP in the server product. Actually, FileZilla Server only support FTPS on the server. :) -Dan

Re: FTPS

2007-07-03 Thread Judah McAuley
Dan G. Switzer, II wrote: I've seen differing support for the two protocols. Filezilla, for instance, support SFTP and FTPS on the client, but only supports SFTP in the server product. Actually, FileZilla Server only support FTPS on the server. :) This is the problem with having FTPS

RE: FTPS

2007-07-03 Thread Jim Rising
Der duh der... I guess I could read the whole post... He actually said he was familiar with sftp.cfc and that it wasn't working for him. Jake... In order to use sftp.cfc ... You need to setup a SSH server like openSSH. It will not work over FTPS (SSL). Jim Rising Sr. Cold Fusion Developer

RE: FTPS

2007-07-03 Thread Jim Rising
- From: Jake Pilgrim [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 11:36 AM To: CF-Talk Subject: FTPS Does anyone know of a way I can connect to an FTPS (FTP over SSL) server using coldfusion? I have seen the sftp.cfc download out there, but SFTP is a different protocol and this CFC

RE: FTPS

2007-07-03 Thread Adrian Wagner
I used Drew's CFX - while you usually just read about it's SFTP capabilities, there actually is a FTPS (which we use and can recommend) version of it. http://www.sagewire.org/advanced-cfml-techniques/Secure-FTP-SFTP-in-Cold -Fusion-98733.aspx (The reference to his email address is at the end

RE: FTPS? (was RE: SFTP?)

2005-10-12 Thread Kevin Graeme
Thanks. That fits with what I already knew. Based both my own experience and yours regarding using SFTP over FTPS, it makes me wonder why whenever there's a request for FTP servers recommendation thread that it only includes servers that use FTPS. Do most people just not use the security? I

RE: FTPS? (was RE: SFTP?)

2005-10-11 Thread Kevin Graeme
Related to this, can someone point me to a comparison of the two? I understand that SFTP is SSH file transfer and FTPS is FTP with SSL, but what are the tradeoffs between them if any? In my experience it seems that unix administrators seem inclined to use SFTP while most easy to administer FTP

RE: FTPS? (was RE: SFTP?)

2005-10-11 Thread Damien McKenna
-Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED] Related to this, can someone point me to a comparison of the two? I understand that SFTP is SSH file transfer and FTPS is FTP with SSL, but what are the tradeoffs between them if any? FTPS is a file transport layer

FTPS? (was RE: SFTP?)

2005-06-08 Thread Chris Terrebonne
Actually, I had my acronym backwards (which apparently makes a HUGE difference :). I am really looking for FTPS ability (FTP over SSL). Sorry for the confusion. Any idea where I can find a CF resource for that protocol? Thanks again, Chris [EMAIL PROTECTED] 06/08/05 08:58AM Can CF do

RE: FTPS? (was RE: SFTP?)

2005-06-08 Thread Paul Vernon
In that case, you could proxy the connection through stunnel. Http://www.stunnel.org Paul ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application

Re: FTPS? (was RE: SFTP?)

2005-06-08 Thread Ken Ferguson
http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=26929forumid=4 (sorry if that wraps) --Ferg Chris Terrebonne wrote: Actually, I had my acronym backwards (which apparently makes a HUGE difference :). I am really looking for FTPS ability (FTP over SSL). Sorry

RE: FTPS? (was RE: SFTP?)

2005-06-08 Thread Dave Watts
Actually, I had my acronym backwards (which apparently makes a HUGE difference :). I am really looking for FTPS ability (FTP over SSL). Sorry for the confusion. Any idea where I can find a CF resource for that protocol? The library I pointed you to does FTPS as well as SFTP. Dave Watts

RE: FTPS? (was RE: SFTP?)

2005-06-08 Thread Chris Terrebonne
Thanks for the help everyone. I'll start digging through those libs and see what I can use. Thanks again, Chris [EMAIL PROTECTED] 06/08/05 10:06AM Actually, I had my acronym backwards (which apparently makes a HUGE difference :). I am really looking for FTPS ability (FTP over SSL