About data type

dodo · #1 (**permalink**) 12-22-02, 04:31

Hi,

Does it exist a data type "blob" in Sybase ? If not, how to stock images in Sybase ?

Thanks

osy45 · #2 (**permalink**) 12-22-02, 13:01

Sybase has a text datatype which can be compared to Oracle's blob datatype.

Bernd Dulfer · #3 (**permalink**) 12-23-02, 04:38

Does it exist a data type "blob" in Sybase ? If not, how to stock images in Sybase ?

Sybase ASE has a text and a image datatype.
Both can handle large amounts of data, like images.

The text datatype is more like a very long varchar. When storing data in a text column, characterset conversion takes place.
Data in image columns is stored 'as is', that is what you want for images.

The image datatype is what you want.

dodo · #4 (**permalink**) 12-23-02, 05:12

Thanks a lot for information !!!

Quote:

Originally posted by Bernd Dulfer

Does it exist a data type "blob" in Sybase ? If not, how to stock images in Sybase ?

Sybase ASE has a text and a image datatype.
Both can handle large amounts of data, like images.

The text datatype is more like a very long varchar. When storing data in a text column, characterset conversion takes place.
Data in image columns is stored 'as is', that is what you want for images.

The image datatype is what you want.

Internet Services

Web Development

Digital Marketing

Consumer Tech