All Forums Database
HateOra 17 posts Joined 10/13
10 Jun 2014
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:
Raja_KT 1246 posts Joined 07/09
11 Jun 2014

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/Conversion_Functions.097.010.html
and also inter conversion:
http://forums.teradata.com/forum/database/cast-charvarchar-to-varbyte

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

dnoeth 4628 posts Joined 11/04
11 Jun 2014

@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.

Dieter

HateOra 17 posts Joined 10/13
11 Jun 2014

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

You must sign in to leave a comment.