aspose file tools
The moose likes JDBC and the fly likes Sybase blob column type Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Sybase blob column type" Watch "Sybase blob column type" New topic
Author

Sybase blob column type

Shiva Battula
Greenhorn

Joined: Jun 06, 2005
Posts: 20
Hi,
Iam using Sysbase DB to store word documents.
I was stuck to choose the column type for storing word documents.( I think word documents nothing but BLOBs). Sybase wont support BLOB column type, But indirectly it has a specific column type to store big objects.
Can anyone help me out in choosing column type for BLOBs in Sybase?

Thanks,
Sivasankar


SCJP and SCWCD.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 26496
    
  78

Sivasankar,
As a recall, Sybase provides IMAGE as a BLOB type. Even though your document isn't an image, you can still use one this type. A doc file is just binary data - like an image is.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Shiva Battula
Greenhorn

Joined: Jun 06, 2005
Posts: 20
Thanks Jeanne..Its working fine..
Sivasankar
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Sybase blob column type
 
Similar Threads
loading images and sound files
Stroring Word Documents into MYSQL Database
Stroring Word Documents into MYSQL Database
Store word documents as blobs using base 64 encoding
Inserting images in to the database