Home > Archive > SQL Anywhere ultralite > May 2005 > 64KB Binary patch for Ultralite









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author 64KB Binary patch for Ultralite
Jan

2005-05-19, 7:23 am

Hi there,

Apparently there is a patch available to enable one to write up to 64KB into
a binary field on Ultralite.

Does anybody where I could get the patch?

Thanks

Jan


Greg Fenton

2005-05-19, 9:23 am

Jan wrote:
> Apparently there is a patch available to enable one to write up to 64KB into
> a binary field on Ultralite.
>


Answered in the general newsgroup. Please do not post to multiple
newsgroups (note: this was the more appropriate group).

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
Michael Thode

2005-05-19, 1:23 pm

If your programming in ESQL use the DECL_LONGBINARY as the host variable.
These will give you up to 64KB of data. Note that your column must be LONG
BINARY. The limit on normal BINARY columns is much smaller <4K. You most
likely don't need a patch for this. This functionality was added in version
8.0.0.

If you're programming in one of Ultralite's newer interfaces for example the
C++ interface (9.0.2) then there is no limit to the size of data stored in a
LONG BINARY column. Use the StreamWriter interface.

Mike

"Jan" <jan@cyberprop.com> wrote in message news:428c5fcd@forums
-1-dub...
> Hi there,
>
> Apparently there is a patch available to enable one to write up to 64KB

into
> a binary field on Ultralite.
>
> Does anybody where I could get the patch?
>
> Thanks
>
> Jan
>
>



Gregg Vine

2005-05-20, 9:23 am



Ok - I've had a chat with the developer who wrote the POD that runs on the
device.

The POD is written in Visual Embedded C. The ultralite table has a LONG
BINARY field, we called it picbin.

Currently when writing more than 32KB to that field it's clipping the image
(binary data)...

Could this be a limitation of Visual Embedded C.


Thanks!

"Michael Thode" < mthode_no_spam@sybas
e.com> wrote in message
news:428cdc50@forums
-2-dub...
> If your programming in ESQL use the DECL_LONGBINARY as the host variable.
> These will give you up to 64KB of data. Note that your column must be

LONG
> BINARY. The limit on normal BINARY columns is much smaller <4K. You most
> likely don't need a patch for this. This functionality was added in

version
> 8.0.0.
>
> If you're programming in one of Ultralite's newer interfaces for example

the
> C++ interface (9.0.2) then there is no limit to the size of data stored in

a
> LONG BINARY column. Use the StreamWriter interface.
>
> Mike
>
> "Jan" <jan@cyberprop.com> wrote in message news:428c5fcd@forums
-1-dub...
> into
>
>



Michael Thode

2005-05-20, 11:23 am

We'd need more information about the application in order to determine the
problem. What version of UL is being used? Post a sample of the
application code if possible.

Mike

"Gregg Vine" <greggv@sybase.co.za> wrote in message
news:428df832@forums
-2-dub...
>
>
> Ok - I've had a chat with the developer who wrote the POD that runs on the
> device.
>
> The POD is written in Visual Embedded C. The ultralite table has a LONG
> BINARY field, we called it picbin.
>
> Currently when writing more than 32KB to that field it's clipping the

image

> (binary data)...
>
> Could this be a limitation of Visual Embedded C.
>
>
> Thanks!
>
> "Michael Thode" < mthode_no_spam@sybas
e.com> wrote in message
> news:428cdc50@forums
-2-dub...
variable.[color=darkred]
> LONG
most[color=darkred]
> version
> the
in[color=darkred]
> a
64KB[color=darkred]
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com