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.