EOModeler NSData and varbinary save error

"Ty Shipman, CIO/CTO, Kagi" <[email protected]> Wed, 7 Apr 2004 14:26:07 -0700
Newsgroups gmane.comp.web.webobjects.eof
Message-ID <p06020403bc9a0dd06edb@[157.22.137.101]>
Fellow WOE users:

So we are using Sybase and WOE 5.2 on Mac OS X 10.2.8 -- JDBC adaptor

The code works in 4.5 WOE on NT -- C adaptor

We are attempting to port it to 5.2

I have a column in my database that is defined as varbinary(255), I 
can select the data no problem in 5.2, but when I go to change it I 
get the following error.


Next exception:SQL State:42000 -- error code: 257 -- msg: Implicit 
conversion from datatype 'IMAGE' to 'VARBINARY' is not allowed. Use 
the CONVERT function to run this query.

The column in EOModeler has the following definitions:

Name:		vfield
Value Class:	NSData
Ext. Type:	varbinary
Length:		255
Value Type:	(blank)
Value Class(java): NSData
Nullable:	yes

The "Value Type" is blank.  I have tried a few of the conversions 
that I thought might make since, but nothing worked.  Is there a 
conversion specifier to NSData (that is not documented) so it is 
converted to binary and not IMAGE type when the save happens?  Or, do 
I have to recode it somehow?

I am not sure if this is a bug or user error on my part?

Any help would be greatly appreciated.

Regards
ty



-- 
I am trying to become obsolete.   But I can not because I am autodidactic.

That is why I put lots of comments into the code, so I could forget.