A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Reading BLOB fields from the database
Migrated From Jforum.net
Joined: Apr 22, 2012
Sep 03, 2008 09:46:13
I would like to read post text directly from the database with SQL. However, since the field is a blob the result is not readable.
I have tried the following SQL:
select utl_raw.cast_to_varchar2(dbms_lob.substr(j.post_text, 100, 1)) from JFORUM_POSTS_TEXT j; select utl_raw.cast_to_varchar2(j.post_text) from JFORUM_POSTS_TEXT j;
Does anyone have a clue?
I'm using JForum 2.1.6 with Oracle 9.
[originally posted on jforum.net by frankern]
I agree. Here's the link:
subject: Reading BLOB fields from the database
Search doesn't work after the crash
Quartz Scheduler - CPU Intesive/DB Intensive
Any datatype to store files of size greater than 20k
reading BLOB type
java.sql.sqlexception data size bigger than max size for this type
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013