Hi,
I want to write a sql query to select the BLOB (binary large object) with size greater than 7MB from the table.
Can anyone hellp me with this?
kind regards,
Ken
sql query to select BLOB
Previous topic • Next topic • 2 posts
• Page 1 of 1
sql query to select BLOB
by KEN » Tue Jun 08, 2010 5:49 pm
- KEN
- Posts: 7
- Joined: Tue Apr 27, 2010 4:35 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: sql query to select BLOB
by dick scherrer » Wed Jun 09, 2010 12:07 am
Hello,
What have you tried? What problem/confusion was encountered?
From the V8 SQL manual:
What have you tried? What problem/confusion was encountered?
From the V8 SQL manual:
A binary large object (BLOB) is a varying-length string with a maximum length of 2 147 483 647 bytes (2 gigabytes minus 1 byte).
Hope this helps,
d.sch.
d.sch.
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Previous topic • Next topic • 2 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- Select query help
by mathew28 » Fri Mar 16, 2012 1:13 am - 4 Replies
- 2393 Views
- Last post by GuyC
Fri Mar 16, 2012 3:37 pm
- Select query help
-
- Using WHERE Clause in SELECT Query
by saurabhgupta86 » Sun Jul 14, 2013 7:38 pm - 1 Replies
- 2373 Views
- Last post by dick scherrer
Mon Jul 15, 2013 1:12 am
- Using WHERE Clause in SELECT Query
-
- Regarding Dynamic values - Select Query
by ramrajgkmf » Tue May 29, 2018 11:13 pm - 0 Replies
- 1850 Views
- Last post by ramrajgkmf
Tue May 29, 2018 11:13 pm
- Regarding Dynamic values - Select Query
-
- Need Help on Select Query to satisfy one of the Search field
1, 2by Chandra_n » Wed Jul 16, 2008 2:51 pm - 10 Replies
- 5360 Views
- Last post by Chandra_n
Wed Jul 23, 2008 11:12 am
- Need Help on Select Query to satisfy one of the Search field
-
- Query: select " " from tablename
by bodhi » Wed Aug 08, 2007 12:38 pm - 3 Replies
- 3305 Views
- Last post by dick scherrer
Thu Aug 09, 2007 9:08 pm
- Query: select " " from tablename