Blobs are for images and alike, you will need a clob for text.
"This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Brent Nicholas To: CF-Talk Sent: Fri Aug 25 21:04:13 2006 Subject: Save the BLOB :) So the DB peeps here have decided to lay the Oracle BLOB on me... woo hoo. Anyway, I figured out that you have to use CFQUERYPARAM to get the data in. ex:<cfqueryparam value="#Binarydecode(TextAreaContent,"Base64")#" cfsqltype="cf_sql_blob"> Though I'm not sure if the funtion is correct, it doesn't error out like it would without it. Then I use this to display the content from the DB on the page: #BinaryEncode(DBColumn,"Base64")# Only problem I'm having is that the resulting string is missing all of the spaces. Ex: I save the string: "Run this test and see if it works all perty." When pulling it out of the DB using the function above I get: "Runthistestandseeifitworksallperty." Has anyone dealt with this before? Thanks for your time - BrentNicholas($$).work; ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
