Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Storing Graphics (.gif, .jpg, etc) in a database table

4 posts in General Discussion Last posting was on 2006-07-07 20:15:46.0Z
Cary Lewis Posted on 2006-07-05 14:14:06.0Z
Sender: 2632.44abc674.1804289383@sybase.com
From: Cary Lewis
Newsgroups: ianywhere.public.general
Subject: Storing Graphics (.gif, .jpg, etc) in a database table
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44abc92e.264d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 Jul 2006 07:14:06 -0700
X-Trace: forums-1-dub 1152108846 10.22.241.41 (5 Jul 2006 07:14:06 -0700)
X-Original-Trace: 5 Jul 2006 07:14:06 -0700, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5479
Article PK: 1525

Has anyone had any success storing actual binary data
(pictures, .wav files, etc.) in a mobile ianywhere database?

How much binary data can one database column store?


"Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g Posted on 2006-07-05 15:22:15.0Z
From: "Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Storing Graphics (.gif, .jpg, etc) in a database table
References: <44abc92e.264d.1681692777@sybase.com>
In-Reply-To: <44abc92e.264d.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <44abd927$1@forums-1-dub>
Date: 5 Jul 2006 08:22:15 -0700
X-Trace: forums-1-dub 1152112935 10.25.98.170 (5 Jul 2006 08:22:15 -0700)
X-Original-Trace: 5 Jul 2006 08:22:15 -0700, keating-dm20.sybase.com
Lines: 37
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5480
Article PK: 1526

Can you be more specific as to which iAnwyhere database product you are
using? Is this simply to see if it works or are you having a problem? If
the later, what specifically are you encountering.

--
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Register now for TechWave 2006 August 6-10 in Las Vegas. New! 2-day
and 4-day options for SQL Anywhere technical training.
Sessions will focus on data management, data movement, and SQL Anywhere
10. Visit www.sybase.com/techwave


*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Breck Carter [Team iAnywhere] Posted on 2006-07-07 20:15:46.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Storing Graphics (.gif, .jpg, etc) in a database table
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <7bfta2tnqliahbb37iahs5fci26bhouuq9@4ax.com>
References: <44abc92e.264d.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 7 Jul 2006 13:15:46 -0700
X-Trace: forums-1-dub 1152303346 64.7.134.118 (7 Jul 2006 13:15:46 -0700)
X-Original-Trace: 7 Jul 2006 13:15:46 -0700, bcarter.sentex.ca
Lines: 30
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5491
Article PK: 1536


On 5 Jul 2006 07:14:06 -0700, Cary Lewis wrote:

>Has anyone had any success storing actual binary data
>(pictures, .wav files, etc.) in a mobile ianywhere database?
>
>How much binary data can one database column store?

Lots and lots, depending on the platform.

Check out the guy standing in the creek, his V9 database holds lots of
high-res pictures and speech clips on a Tablet PC:
http://www.developer.com/db/article.php/10920_3526161_1

And these folks capture LONG BINARY time series measurements in
sideline laptops running V9: http://www.simbex.com/HITS.html

Here's a tip: If you are updating other columns while a blob column
stays unchanged, you can avoid excess synchronization traffic by
putting the blob in a separate table; MobiLink syncs rows, not
columns.

Breck


--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Stephen Rice Posted on 2006-07-07 19:55:49.0Z
From: "Stephen Rice" <sriceATianywhereDOTcom>
Newsgroups: ianywhere.public.general
References: <44abc92e.264d.1681692777@sybase.com>
Subject: Re: Storing Graphics (.gif, .jpg, etc) in a database table
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: srice-xp2.sybase.com
Message-ID: <44aebada$1@forums-2-dub>
X-Original-Trace: 7 Jul 2006 12:49:46 -0700, srice-xp2.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 7 Jul 2006 12:49:49 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 7 Jul 2006 12:55:49 -0700
X-Trace: forums-1-dub 1152302149 10.22.108.75 (7 Jul 2006 12:55:49 -0700)
X-Original-Trace: 7 Jul 2006 12:55:49 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5490
Article PK: 1537

Size limitations are documented in the manuals and are platform dependant.
--
/steve

Stephen Rice
Technical Services Manager
iAnywhere (a Sybase Company)
email: srice@ianywhere.com

* Register now for TechWave 2006 August 6-10 in Las Vegas Join us for
detailed product training tracks on Afaria, RemoteWare, OneBridge, SQL
Anywhere and Advantage Database. Visit www.sybase.com/techwave

<Cary Lewis> wrote in message news:44abc92e.264d.1681692777@sybase.com...
> Has anyone had any success storing actual binary data
> (pictures, .wav files, etc.) in a mobile ianywhere database?
>
> How much binary data can one database column store?