dbTalk Databases Forums  

Getting Binary Data out of a LONG data type

comp.databases.gupta comp.databases.gupta


Discuss Getting Binary Data out of a LONG data type in the comp.databases.gupta forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Erik Voldengen
 
Posts: n/a

Default Getting Binary Data out of a LONG data type - 06-08-2004 , 03:37 PM






I am having a horrible time getting some binary data out of a SQLbase
database.

I'm running 8.5, and I've updated to the latest drivers on the Gupta
website.

I'm connecting to the DB via the ODBC driver. Whenever I query data
out of this binary column, it's coming over as ASCII. Same with the
JDBC driver. I don't know what else to do going this route.

I'd really like to use SQL Server and DTS the data over, but that,
too, brings the data over as ASCII rather than binary. I've tried
using DTS with Gupta's ODBC and OLE. SQL Server DTS, by default,
assigns the "text" data type to a column of type "LONG" in SQLbase.
And I can't transform it to something more appropriate, say IMAGE,
because it's viewed as a text field by SQL Server.

Anyone have any suggestions as to what I could do?

Thanks,
Erik

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.