The process works with a jpeg for me, but when I try to use it on a pdf it fails when converting back to a binary. Seems there's a discrepency between tobase64 that leaves + and / characters, tobinary fails with those characters. I guess I'll keep playing with it.
-----Original Message----- From: Sicular, Alexander [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 2:22 PM To: CF-Talk Subject: RE: tobase64 That article should work. My system works more or less the same. The sql datatype needs to be 'text', not 'image'. Cf won't send a binary through an sql statement. That's why you need to tobase64 it. The result is an ascii safe string of text. The downside is that the base64 version of the binary file is ~33% larger. Gl, Alexander Sicular Chief Technology Architect Neurological Institute of New York Columbia University as867 [at] columbia {dot} edu |-----Original Message----- |From: Turetsky, Seth [mailto:[EMAIL PROTECTED]] |Sent: Thursday, January 23, 2003 1:00 PM |To: CF-Talk |Subject: tobase64 | | |I posted this on another list but didn't get a reply: | |I was following this tutorial for storing binary files in a |database: |http://is.curtin.edu.au/ics/web/resources/binary_files_with_oracle.htm | |I'm using sql server for this which shouldn't matter, but it |seems my problem is with the toBase64 function, when i run |that for example on a pdf, I see a lot of +'s and /'s left, so |when I try to convert back, tobinary fails saying my string |should be a base64-encoded string. If I manually remove those |characters, then the tobinary works since it's a valid base64 |string then. | |Anyone know why the tobase64 function leaves those characters in? | |thanks, |seth | |This message is for the named person's use only. It may |contain sensitive and private proprietary or legally |privileged information. No confidentiality or privilege is |waived or lost by any mistransmission. If you are not the |intended recipient, please immediately delete it and all |copies of it from your system, destroy any hard copies of it |and notify the sender. You must not, directly or indirectly, |use, disclose, distribute, print, or copy any part of this |message if you are not the intended recipient. CREDIT SUISSE |GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON |or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT |SUISSE FIRST BOSTON reserve the right to monitor all e-mail |communications through its networks. Any views expressed in |this message are those of the individual sender, except where |the message states otherwise and the sender is authorized to |state them to be the views of any such entity. Unless |otherwise stated, any pricing information given in this |message is indicative only, is subject to change and does not |constitute an offer to deal at any price quoted. Any reference |to the terms of executed transactions should be treated as |preliminary only and subject to our formal written confirmation. | | | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
