How to read VARBYTE

Database
Enthusiast

How to read VARBYTE

Hi,

We have a table in which we have a field which is defined as VARBYTE. 

could you pleae let me know if there is a way to read the VARBYTE data in readable format ?

Tags (1)
3 REPLIES
Enthusiast

Re: How to read VARBYTE

Which TD version you have?

Do you use FROM_BYTES function ?

Maybe these links can help you?

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_111A/Conv...

and also inter conversion:

http://forums.teradata.com/forum/database/cast-charvarchar-to-varbyte

Senior Apprentice

Re: How to read VARBYTE

@HateOra:

Define "readable format" :-)

It's binary, so you (or you application) should know what it's supposed to be, e.g. JPEG, MP3, etc.

Enthusiast

Re: How to read VARBYTE

We have TD 13 verion. Its a text that i want to present into a readable format, currently its in VARBYTE.